| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Not
If cell a1 is not blank, then I want 998 in cell c1, else 999. How do I write
this? I tried =IF(NOT(ISBLANK(A1,998,999). Thanks, -- Howard |
|
#2
|
|||
|
|||
|
=if(ISBLANK(A1),999,998)
Should work "Howard" wrote: If cell a1 is not blank, then I want 998 in cell c1, else 999. How do I write this? I tried =IF(NOT(ISBLANK(A1,998,999). Thanks, -- Howard |
|
#3
|
|||
|
|||
|
Thanks! Of course, I don't need "NOT."
HF "Steve" wrote: =if(ISBLANK(A1),999,998) Should work "Howard" wrote: If cell a1 is not blank, then I want 998 in cell c1, else 999. How do I write this? I tried =IF(NOT(ISBLANK(A1,998,999). Thanks, -- Howard |
|
#4
|
|||
|
|||
|
Its true that you don't need the NOT but your formula would have worked if
you had closed the brackets. =IF(NOT(ISBLANK(A1)),998,999) Sandy -- to e-mail direct replace @mailintor.com with @tiscali.co.uk "Howard" wrote in message ... Thanks! Of course, I don't need "NOT." HF "Steve" wrote: =if(ISBLANK(A1),999,998) Should work "Howard" wrote: If cell a1 is not blank, then I want 998 in cell c1, else 999. How do I write this? I tried =IF(NOT(ISBLANK(A1,998,999). Thanks, -- Howard |
|
#5
|
|||
|
|||
|
Thanks very much. Those pesky little brackets!
HF "Sandy Mann" wrote: Its true that you don't need the NOT but your formula would have worked if you had closed the brackets. =IF(NOT(ISBLANK(A1)),998,999) Sandy -- to e-mail direct replace @mailintor.com with @tiscali.co.uk "Howard" wrote in message ... Thanks! Of course, I don't need "NOT." HF "Steve" wrote: =if(ISBLANK(A1),999,998) Should work "Howard" wrote: If cell a1 is not blank, then I want 998 in cell c1, else 999. How do I write this? I tried =IF(NOT(ISBLANK(A1,998,999). Thanks, -- Howard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
