![]() |
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?! |
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?! |
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?! |
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