Hello All,
I am trying to modify an existing If Statement that works. However, I now need it to include an additional column
=IF(AND(NOT(M10=""),(NOT(M10="SUPERSEEDED"))),"REVIEWED",IF(M10="SUPERSEEDED","SUPERSEEDED",IF(F10="","WAITING ON SUB-TRADE",IF(H10>=TODAY(),"WAITING ON CONSULTANT - ON TIME",IF(H10<TODAY(),"WAITING ON CONSULTANT - OVERDUE","ERROR")))))
I need to add one more if statement that says IF(H10 <TODAY() and L10<TODAY(),”Revise And Resubmit” however, when I add this section it only returns the results for H10<Today. Help.
Bookmarks