If formula

[Mohamed]

I have a column sometimes it have dates and sometimes blank. i want to create
a formula "if there is any date, get me a result with "done", if there is no
date get me a result with "not done". for example

Coulmn A Column B
14-8-2002 Done
Blank Not Done

 

[Don]

Hi Mohamed,

Assuming you mean empty by blank and not the
text "blank"...Try this:

=IF(A1="","Not Done","Done")

HTH,

Don

 

[Biff]

Hi!

Try one of these:

=IF(A1="","Not Done","Done")
=IF(ISBLANK(A1),"Not Done","Done")
=IF(ISNUMBER(A1), "Done","Not Done")

Biff