Re-post as I still can't seem to get this to work 100%
- From: Danny Boy <DannyBoy@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 17 Feb 2009 15:06:03 -0800
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!
.
- Follow-Ups:
- Re: Re-post as I still can't seem to get this to work 100%
- From: joeu2004
- Re: Re-post as I still can't seem to get this to work 100%
- From: joeu2004
- Re: Re-post as I still can't seem to get this to work 100%
- From: Ashish Mathur
- Re: Re-post as I still can't seem to get this to work 100%
- Prev by Date: RE: find a value in a table based on 2 different criteria
- Next by Date: Re: Re-post as I still can't seem to get this to work 100%
- Previous by thread: Compare cells in different worksheets
- Next by thread: Re: Re-post as I still can't seem to get this to work 100%
- Index(es):
Loading