I disagree.
So far, you haven't catered for all possibilities if D2="NO". Under that, you've provided for:
• B2>$H$1
• B2<H$1,E2=0
but what about
:
• B2=$H$1
• B2<H$1,E2<>0
Likewise for D2="YES", you've provided for:
• B2>=$H$1,E2>=$H$1
• B2<$H$1,E2>=$H$1
• B2<$H$1,E2<$H$1
but what about
:
• B2>=$H$1,E2<$H$1
You also haven't catered for D2="".
Your latest formula can be simplified to:
Code:
=IF(B2+C2=0,"Delivery date needed",IF(C2>0,"Services",IF(D2="NO",IF(B2>$H$1,"Schedule not due yet",IF(AND(B2<H$1,E2=0),"Missing","")),IF(D2="YES",IF(AND(B2>=$H$1,E2>=$H$1),"Proactive",IF(AND(B2<$H$1,E2>=$H$1),"Current",IF(AND(B2<$H$1,E2<$H$1),"Expired",""))),""))))
the ',""' parts are where you need to sort out the rules for the missing conditions.