CODEWITHSUNDEEP
excelif-statementexcel-formula
Tyler
Tyler

Reputation: 626

Formulate response in excel referencing value in Cell

need a little help with IF & OR to formulate response base on value in Cell M8, I believe i'm very close to what I want but I don't understand the error it.

Ultimately I want the formula to perform the following function

=IF(M8="No Access","No Access", (ABS(M8)>=61,"Exceeded Pre-Determined Level" OR(ABS(M8)>=43,"Exceeded Alert Level")))

Upvotes: 0

Views: 42

Answers (3)

mgae2m
mgae2m

Reputation: 1142

I suggest you using absolute references in this case as:

(With note that you have tried absolute numbers)

=IF($M$8="No Access",$M$8,
IF(ABS($M$8)>=61,"Exceeded Pre-Determined Level",
IF(AND(ABS($M$8)>=43,ABS($M$8)<=61), "Exceeded Alert Level",
"None of them")))

And your system separating character may , or ;.

Breaking formula with Alt + Enter

Upvotes: 1

Vityata
Vityata

Reputation: 43595

Try like this:

=IF(M8="No Access";M8;
IF(M8>=61;"Ex eed Pre-Determined Level";
IF(AND(M8>43;M8<61);"Exceed Alert Level";
"I guess it Is ok")))

You may need to change the ; to ,, depending on your formula separator. Whenever you write complicated Excel formulas, it is always good to write them on a few lines, using ALT + Enter on the formula bar.

Upvotes: 1

Pierre44
Pierre44

Reputation: 1741

Solution just using another If:

=IF(M8="No Access";"No Access";IF(ABS(M8)>=61;"Exceeded Pre-Determined Level";IF(ABS(M8)>=43;"Exceeded Alert Level";"")))

In this case you don t need an "Or", "Or" would give you the same result for the 2 different logic tests.

Upvotes: 1

Related Questions