MrExcel Publishing
Your One Stop for Excel Tips & Solutions

nested IF (OR) function problem

Posted by Pat Bennett on August 13, 2001 6:31 PM

I need to test a cell for 3 values, 0, >0 or <0. I need the result of the test to be " ", POSITIVE or NEGATIVE. My current IF statment reads:

=IF(A1=0," ",(OR(A1>0,A1<0,POSITIVE,NEGATIVE)))

When the value=0 in the cell, the formula works, but if the value is >0 or <0 I get a #VALUE error message.

I don't know what I'm doing wrong. HELP!

Posted by Robb on August 13, 2001 7:08 PM


Try entering as nested a "IF":
=IF(A1=0," ",IF(A1>0,"POSITIVE","NEGATIVE"))

That help?

Posted by Aladin Akyurek on August 14, 2001 2:32 AM

=IF(A1>0,"Positive",IF(A1 < 0,"Negative",""))