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:
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!