if statement when cell is blank

  • Thread starter Thread starter davisk
  • Start date Start date
D

davisk

If G3 is a date and F3 is equal to
IF(G3>TODAY()-2,"OPEN",IF(G3<TODAY()-3,"PAST DUE"))
How do I return "n/a" to F3 if G3 is left blank?
 
I notice you do not have anything in the FALSE condition of your 2nd IF
statement to handle dates in G3 exactly equal to TODAY()-2 and TODAY()-3...
the formula reports FALSE for those two dates. Perhaps you meant >= and <=
instead of > and < in both of your IF tests?

Anyway, to do what you want, put this...

IF(G3="","N/A",

in front of your current formula (after the = sign, of course) and put a
closing parenthesis after at the end. Using your posted formula, the above
comments notwithstanding, this is what the formula becomes after doing
that...

=IF(G3="","N/A",IF(G3>TODAY()-2,"OPEN",IF(G3<TODAY()-3,"PAST DUE")))

Rick
 
Can I also add "Closed" to same formula if another cell other than G3 is
populated w/"yes"?
 
Back
Top