I have columns that give me a days remaining and the column before that gives me 90/60/30 day warning.
C1 is =(C1)-NOW()
What I would like to do do is when it's negative, it will display "OVERDUE"
Can somebody help?
Thank you!
-Michael
A | B | C | |
1 | 20090602 | 30 DAYS | 16 |
2 | 20181112 | 0 | -181 |
3 | |||
C1 is =(C1)-NOW()
What I would like to do do is when it's negative, it will display "OVERDUE"
Can somebody help?
Thank you!
-Michael