View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GPearson GPearson is offline
external usenet poster
 
Posts: 7
Default If Function with multiple criteria

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?