Adding in a piece of logic to my complicated formula!
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
|