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