simple nested IF statement needed

[lvaumsb]

Hi all,

i am trying to write an 'if' statement that basically does three things and returns three different answers.

Column A is either blank or has a date in it. If the cell is blank i want it to return "blank", if the date is > or = today() return "BOOKED" and if it is < or = today() "completed".

Just having problems getting this into one formula.

Many thanks in advance for any help,

Matt

 

[lenze]

=IF(ISBLANK(A1),"",IF(A1>=TODAY(),"BOOKED","COMPLETED"))

 

[IML]

I'd go with Lenze's, but just for variety:
=CHOOSE(1+(LEN(A1)>0)+(A1>=TODAY()),"","complete","overdue")

 

[lvaumsb]

Many thanks to the both of you.

Incredibly simple i know!!