If forumla question - urgent! Help!

[GEDMUNDSON]

Hello,

I've created a document that indicates whether or not we've received a missing document. So you understand the help I need, let me give you the story. There is a due date for us to receive a missing document. So I've entered this formula:

=IF(J3<=I3,"TIMELY","LATE")
Cell J3 = Received Date
Cell I3 = Due Date

So for example if the due date is 5/6/14, and the received date is less than or equal to the due date, the cell changes to timely, otherwise "LATE" will show up.

However, while we're waiting on missing documents, we wont enter any value at all in Cell J3, because obviously we haven't received the document yet. In that situation, the formula will still come up as "TIMELY" which is not accurate. How could the entry be timely if we haven't even received the missing document yet? What I'd like is something like the following formula, but I don't know how to enter it:

=IF(J3<=I3,"TIMELY","LATE", BUT IF J3=0, THEN "NOT RECEIVED")

Please help! Thanks!

 

[VoG]

Try

=IF(J3="","NOT RECEIVED",IF(J3<=I3,"TIMELY","LATE"))

 

[GEDMUNDSON]

That was perfect! Did exactly what I wanted it to! Thanks!