IF statement help

[bfaws]

Hello,

I`m hoping somebody can help. I have an if statement which works well for my purposes but i would like to had a new element to it but I`m not sure how. See below what it currently looks like.


=IF(OR(LEN(A2)=0,LEN(K2)<>0),"",IF(O2<0,"Still Time",IF(O2=0,"Due Today",IF(O2>0,"Overdue"))))


Basically it says that if the number in cell O2 is:

<0 then "still time"
=0 then "due today"
>0 then "overdue"

What i would like added is:

if O2 is blank (no number) then "completed".

Any help would be much appreciated.

Thanks,

Brendan

[sweep]

Hi,

Does this work?

Please Login or Register  to view this content.

[bfaws]

It works perfectly.

Thanks very much