Re-post as I still can't seem to get this to work 100%
I'm having trouble getting the formula below to work after adding the
additional condition of:
Additional Condition:
IF(TODAY()EDATE(M4,3)
Full Formula:
=IF(AND(I4=1,O5="Yes"),"Level 1 Program
Completed",IF(AND(I4=1,O4="No"),"Level 1 Program Not
Completed",IF(AND(I4=2,O4="Yes",P4<""),"Level 2 Program
Completed",IF(TODAY()EDATE(M4,3),AND(I4=2,O4="Yes "),"Level 2 Program Not
Completed",IF(AND(I4=2,O4="No"),"Level 2 Program Not Completed","")))
Any suggestions to rectify this problem?
Thanks for any suggestions!
|