If cell value is < negative number

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

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?!
 
Mike gave you the formula you were looking for, but for reference,
Excel uses the FALSE result in two common situations:
An IF statement is constructed, but no result has been declared for
what should happen if the test is not true
An evaluation is made that results in a not true result - this often
happens mistakenly if an = is typed into an equation instead of a +
(as in "=a1=a2" instead of "=a1+a2")
 
You forgot to tell us what formula you are using.
It should have been =IF(cellref<-.1,"Keep","OLD")
If you are getting FALSE, you've presumably got an IF statement for which
you have specified only 2 of the 3 arguments. If you don't give the 3rd
argument, which is the outcome if the condition is not met, the outcome in
this situation is assumed to be the Boolean FALSE.

In Excel, the F1 key is one way of getting into Excel's help function, and
in there when you type the word IF, it will give you a link to help on the
IF function. If there is any Excel function (other than DATEDIF) on which
you need additional information, Excel help is the place to start.
 
Back
Top