HI

Look at this:

=IF(A2="",IF(B2<C1,"Overdue",""),"")

Regards,
Per

"GPearson" skrev i meddelelsen
...
Hi, I have am trying to use the If function to deliver a value if 2
criteria
are true for 2 different fields. Both contains dates. The first field is
blank or not. The 2nd field is filled in. The criteria I am trying to
find
is if the 1st field is blank and the 2nd field is earlier than today, the
function should deliver the value "Overdue" to the third field. How can I
use the If function to do this?