[GPearson]

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?

[Per Jessen]

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?

[Luke M]

check out the Boolean functions AND & OR

=IF(AND(ISBLANK(Cell1),Cell2<TODAY()),"Overdue","C riteria not met")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"GPearson" wrote:

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?