| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| will this post | Excel Discussion (Misc queries) | |||
| Re Post | Excel Discussion (Misc queries) | |||
| Re-post... | Excel Worksheet Functions | |||
| Should I generally request "post a poll" when I post a new thread? | Excel Discussion (Misc queries) | |||
| My First Post! | Excel Discussion (Misc queries) | |||
Threaded Mode
