Feb 11 2021 04:41 AM
Hi everyone,
I have a set of deadlines in column C, and a "Deadline Ticker" in column D.
I have two sets of formulas:
=IF(C:C<TODAY(),"OVERDUE"," ") - so if the deadline date in column C has passed the cell in column D willl return "OVERDUE", if it has not passed, the cell in column D is left blank
But if there is no date in the cells in C, I dont want it to return anything in column D. So I came up with this formula:
=IF(C:C=""," ","") - So when there is no deadline in C, the cell in D will remain blank
I am having trouble bringing these two formulas together:
If deadline date has passed then enter "OVERDUE", but if the deadline date is blank then leave blank.
I have tried OR and ELSE but I think this is over my head.
Thank you
Feb 11 2021 05:04 AM
SolutionFeb 11 2021 05:18 AM
@Hans Vogelaar Thank you for your reply - it worked!
I am an excel novice, is there any particular reason why one would use
C:C <> " "
rather than
C:C= " "
Feb 11 2021 06:04 AM
It's actually C:C<>"" (without a space between the quotes).
The condition AND(C:C<>"",C:C<TODAY()) says that the cell in column C must not be equal to the empty string "" (i.e. it is filled) and before the current date.
It would have been possible to use C:C="", but that would make the formula longer:
=IF(C:C="", "", IF(C:C<TODAY(), "OVERDUE", ""))
Feb 11 2021 05:04 AM
Solution