One more formula

[dragonmouse]

I want to add two more layers to the formula. If the cell is deferred or has a "date deferred" I'd like the formula to return DEFERRED or else just return the "date" like it normally does or if the item has been removed it returns removed .

What's actually going on is we have to perform "preventative maintenance" on multiple products. They have differing schedules which may be every 7 days, every 14 days, every 6 months or a combination of any two schedules. The formula below returns the next date due and it works PERFECTLY but I forgot one thing. If the product has a problem that is going to require a long lead time to receive a part to fix it the "preventative maintenance" may be deferred until the part is received. I would like one more layer to the formula that if is sees a date in column AD to return the word DEFERRED instead of a "Date" and if it sees a date in column AE to return (REMOVED) instead of a "Date"

=IF(OR(L4=7,O4=14,R4=28,U4=56,X4=168,AA4=336),IF(ISBLANK(L4)*(O4)*(R4)*(U4)*(X4)*(AA4),"",MIN(N4,Q4,T4,W4,Z4,AC4)),"")

Returns the next date due
OR "Deferred"
OR "Removed"

 

[footoo]

=if(ad4<>"","deferred",if(ae4<>"","removed",if(or(l4=7,o4=14,r4=28,u4=56,x4=168,aa4=336),if(isblank(l4)*(o4)*(r4)*(u4)*(x4)*(aa4),"",min(n4,q4,t4,w4,z4,ac4)),"")))

 

[dragonmouse]

It works PERFECTLY. You are truly a MASTER!