Quote:
Originally Posted by z941714
B2>$H$1,E2<$H$1, "Expired"
|
Since that's the same result as for B2<$H$1,E2<$H$1, you can reduce the 'yes' test to:
Code:
IF(D2="YES",IF(AND(B2>=$H$1,E2>=$H$1),"Proactive",IF(E2>=$H$1,"Current","Expired"))
Quote:
Originally Posted by z941714
B2<$H$1,E2<>0, E2<>0 is "Missing" when there a date in E2 if it is greater the $H$1,"Current", if less than "Expired"
|
is ambiguous, but it seems to suggest your overall formula could be expressed as:
Code:
=IF(B2+C2=0,IF(D2="","","Delivery date needed"),IF(C2>0,"Services",IF(D2="NO",IF(B2=$H$1,"Due today",IF(B2>$H$1,"Schedule not due yet",IF(E2=0,"Missing",IF(E2>H$1,"Current","Expired")))),IF(D2="YES",IF(AND(B2>=$H$1,E2>=$H$1),"Proactive",IF(E2>=$H$1,"Current","Expired")),"Error"))))