If Function with multiple criteria

  • Thread starter Thread starter GPearson
  • Start date Start date
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?
 
check out the Boolean functions AND & OR

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