ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   If cell value is < negative number (https://www.excelbanter.com/excel-worksheet-functions/216495-if-cell-value-negative-number.html)

JR

If cell value is < negative number
 
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 H

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


Reitanos

If cell value is < negative number
 
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")

On Jan 14, 12:50*pm, 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?!



David Biddulph[_2_]

If cell value is < negative number
 
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.
--
David Biddulph


"JR" wrote in message
...
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?!





All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com