IF true,then Question

[oncorpse]

Hi,

I use Excel 2007. I want to say if L3 is empty, then say "Not Done", it is not empty (there can be a number in it), then say "Done".

For the first part I say:
=IF(L3<>"";"Done")
and for the second part:
=IF(L3;"";"Not Done")

It works perfectly fine when I use them seperately, but as soon as I put these two together as =IF(L3<>"";"Done");IF(L3;"";"Not Done") it does work anymore. It says #Value! .

What should I do?

Many Thanks

 

[marka87uk]

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

 

[kidwispa]

=IF(ISBLANK(L3),"not done","done")

 

[oncorpse]

Wow, that was quick

Great! It worked (I had to I change , to ; though.
=IF(L3="";"Not Done";"Done")

Many Thanks!

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

 

[oncorpse]

Oh yes, This one worked as well. You guys are just awsome.

many thanks for helping a new exceler out

=IF(ISBLANK(L3),"not done","done")