View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan the Man[_2_] Dan the Man[_2_] is offline
external usenet poster
 
Posts: 145
Default 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