View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny boy Danny boy is offline
external usenet poster
 
Posts: 102
Default 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!