CODEWITHSUNDEEP

excelif-statementexcel-formula

Tyler

Reputation: 626

How do I formulate same response on positive & negative value of the same number?

Current Formula so far

=IF(A1>=99;"Exceeded Suspension Level";IF(A1>=69;"Exceeded Alert Level";IF(A1<=68;"Within Alert Level";IF(A1<=-99;"Exceeded Suspension Level";IF(A1<=-69;"Exceeded Alert Level";IF(A1>=-68;"Within Alert Level"))))))

Need help in getting same response but in negative value. For instance,

68 & below OR 0 to -68 ="Within Alert Level"
Inclusively between 69 and 98 OR -69 to -98 ="Exceeded Alert Level"
99 & Above OR -99 and higher ="Exceeded Suspension Level"

Code not working for negative values.

Upvotes: 1

Views: 68

Answers (2)

Reputation: 164

Check this

=if(ABS(A1)>=99;"Exceeded Suspension Level";if(ABS(A1)>=69;"Exceeded Alert Level";if(abs(A1)<=68;"Within Alert Level")))

Upvotes: 1

OldUgly

Reputation: 2119

Try using the ABS function ...

=IF(ABS(A1)>=99,"Exceeded Suspension Level",IF(ABS(A1)>=69,"Exceeded Alert Level",IF(ABS(A1)<=68,"Within Alert Level")))

Upvotes: 2

Related Questions