dragonmouse
Board Regular
- Joined
- May 14, 2008
- Messages
- 131
- Office Version
- 2016
- Platform
- Windows
I have a spreadsheet when has several different maintenance requirements. The row may have requirements based on weekly, monthly quarterly and annually. My cell returns the "next date due"or a blank if nothing is input and it works PERFECTLY.
I'd like to add one more "level"...IF one of the cells says "DEFERRED" or has a date deferred" in a particular cell, It will return the word "DEFERRED"
=IF(OR(L5=7,O5=14,R5=28,U5=56,X5=168,AA5=336),IF(ISBLANK(L5)*(O5)*(R5)*(U5)*(X5)*(AA5),"",MIN(N5,Q5,T5,W5,Z5,AC5)),"")
Next addition "IF CELL "AD5" has information such as a date, return the word DEFERRED in cell "A5"
Thoughts
I'd like to add one more "level"...IF one of the cells says "DEFERRED" or has a date deferred" in a particular cell, It will return the word "DEFERRED"
=IF(OR(L5=7,O5=14,R5=28,U5=56,X5=168,AA5=336),IF(ISBLANK(L5)*(O5)*(R5)*(U5)*(X5)*(AA5),"",MIN(N5,Q5,T5,W5,Z5,AC5)),"")
Next addition "IF CELL "AD5" has information such as a date, return the word DEFERRED in cell "A5"
Thoughts
