Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Previously I received wonderful help with a very long piece of formula, and
that which you see below works like a charm! =IF(AND(TODAY()EDATE(AL7,12),AA7<"",AL7<"",AN7= "Referred to Tx"),"Updated Eval Needed Before New RF",IF(OR(AA7<"",AND(TODAY()AG7,AN7="AC Initiated")),IF(AND(TODAY()AG7,AN7="AC Initiated"),IF(AQ7="","Check AC Status",IF(AND(TODAY()EDATE(AQ7,6),AN7="AC Initiated"),"Re-Check AC Status","")),IF(AND(TODAY()EDATE(AA7,12),AN7="Ref erred to TX"),IF(AL7="","Eval Before RF",IF(AND(TODAY()EDATE(AL7,6),AN7="Referred to Tx"),"Confirm AC Follow Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),AN7="Referred to Tx"),"Confirm AC Follow Through",""),""))) I have to add in one last line to accomplish the final requirement, and hopefully someone can help me. When I attempt to incorporate the information it doesn't work, however if I put the information into its own stand alone cell it works just fine. Here is the additional piece of formula I'd like to weave into the above "beast": =IF(AND(TODAY()EDATE(AL7,12),AA7="",AL7<"",AN7=" Referred to Tx"),"New Eval Needed","") Not sure if this is enough information for you all, or if you more details about the "requirement" surrounding the logic. Thanks in advance! Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula for commissions on a per piece bases | Excel Worksheet Functions | |||
Logic Formula | Excel Worksheet Functions | |||
Logic formula using Time | Excel Discussion (Misc queries) | |||
Adding something to a complicated formula | Excel Discussion (Misc queries) | |||
Complicated adding | Excel Worksheet Functions |