If cell value is < negative number
Hi
=IF(A1<0.1,"Keep","Old")
Mike
"JR" wrote:
Scenario:
IF cell is less than -.10, "Keep" is the true, "OLD" is the false.
Instead of the word OLD old coming up, the word FALSE is displayed. That's
not even part of my formula! Can someone help?!
|