If Function with multiple criteria

G

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?
 
L

Luke M

check out the Boolean functions AND & OR

=IF(AND(ISBLANK(Cell1),Cell2<TODAY()),"Overdue","Criteria not met")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Multiple If Function 2
countifs Function not giving desired result with date criteria 2
Countif with multiple criteria 4
How do I use DCOUNT with evaluation of multiple columns? 4
Summing a range of cells with criteria 7
DMax with No Criteria 2
Using the CountIf function with multiple criteria? 11

Top