I am having a problem with this formula. =IF(F2="No","Delivery date needed",IF(F2="Yes",IF(C2<>"","Services",IF(D2="NO ",IF(B2>$H$1,"Schedule not due yet",IF(F2="Yes",IF(C2="",IF(D2="NO",IF(B2<H$1,IF( E2="","Missing",IF(F2="Yes",IF(C2="",IF(D2="Yes",I F(B2>=$H$1,IF(E2>=B2,"Proactive")))))))))))))))

Everything working except the last condition. "Proactive"

Attached Files

Delivery Schedule Report ver 2.xlsx (495.7 KB, 13 views)