Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create one additional warning flag into my logic?
I need assistance in editing a portion of the formula below. As it stands
this formula (which I have written into cell (AF4) WORKS, and does exactly what it needs to do, however, Id like to add in one more piece of logic. Currently, the BEGIN ANEW-IDIP 011 & 021 TO DPHS flag triggers if more than (12) months has elapsed from the class ending date identified in Y4. What Id like to do, is to add one ADDITIONAL warning flag that would alert me (1) month PRIOR to the triggering of the BEGIN ANEW-IDIP 011 & 021 TO DPHS flag (giving me an opportunity to contact and advise someone that they have one month before they have to begin the entire curriculum anew). My thought is this: the new flag would trigger 11 months from the class ending date identified in Y4, and it would say Begin Anew-One Month Warning. Prior to 11 months, however, NO flag would trigger in AF4. Once the client gets to the 12 month point however (from the date identified in Y4), than the Begin Anew-One Month Warning flag would go away, and be replaced by the BEGIN ANEW-IDIP 011 & 021 TO DPHS flag (per the current logic below). Thank you in advance for any help! Best, Dan Current Formula in cell AF4 =IF(Y4="","",IF(AB4<"","",IF(AP4<"","",IF(TODAY( )EDATE(Y4,12),(IF(AG4="Sent","$460.00 Re-Start Fee Owed",(IF(AG4="$460.00 Re-Start Fee Paid","","BEGIN ANEW-IDIP 011 & 021 TO DPHS")))),"")))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create one additional warning flag into my logic?
Hi Danny
Try =IF(Y4="","", IF(AB4<"","", IF(AP4<"","", IF(TODAY()EDATE(Y4,12), IF(AG4="Sent","$460.00 Re-Start Fee Owed", IF(AG4="$460.00 Re-Start Fee Paid","","BEGIN ANEW-IDIP 011 & 021 TO DPHS")), IF(TODAY()EDATE(Y4,11),"Begin A New One Month Warning",""))))) This takes you to the limit of nesting in XL2003 or lower. -- Regards Roger Govier "Danny Boy" wrote in message ... I need assistance in editing a portion of the formula below. As it stands this formula (which I have written into cell (AF4) WORKS, and does exactly what it needs to do, however, Id like to add in one more piece of logic. Currently, the BEGIN ANEW-IDIP 011 & 021 TO DPHS flag triggers if more than (12) months has elapsed from the class ending date identified in Y4. What Id like to do, is to add one ADDITIONAL warning flag that would alert me (1) month PRIOR to the triggering of the BEGIN ANEW-IDIP 011 & 021 TO DPHS flag (giving me an opportunity to contact and advise someone that they have one month before they have to begin the entire curriculum anew). My thought is this: the new flag would trigger 11 months from the class ending date identified in Y4, and it would say Begin Anew-One Month Warning. Prior to 11 months, however, NO flag would trigger in AF4. Once the client gets to the 12 month point however (from the date identified in Y4), than the Begin Anew-One Month Warning flag would go away, and be replaced by the BEGIN ANEW-IDIP 011 & 021 TO DPHS flag (per the current logic below). Thank you in advance for any help! Best, Dan Current Formula in cell AF4 =IF(Y4="","",IF(AB4<"","",IF(AP4<"","",IF(TODAY( )EDATE(Y4,12),(IF(AG4="Sent","$460.00 Re-Start Fee Owed",(IF(AG4="$460.00 Re-Start Fee Paid","","BEGIN ANEW-IDIP 011 & 021 TO DPHS")))),"")))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help neededin adding an additional "Warning Flag" to my current lo | Excel Worksheet Functions | |||
Create logic functions like a flip-flop in excel? | Excel Discussion (Misc queries) | |||
create additional rows containing data from one original row | Excel Discussion (Misc queries) | |||
Please respond: Need to create additional measure in pivot table | Excel Discussion (Misc queries) | |||
i need to create an invoice that will flag up when not paid | Excel Discussion (Misc queries) |