Thread: Not
View Single Post
  #2   Report Post  
Steve
 
Posts: n/a
Default
=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 With QuoteReply With Quote