I would like to thanks everyone in advance for any help that is given. I having an issue with this if statement, everything works, except the last condition "Proactive"
=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(D2="Yes",IF(B2>=$H$1,IF(E2>=$H$1,"Proactive"))))))))))))))
Thanks
Z941714
Bookmarks