Need Help Organizing a Formula?

[Guest]

The portion of my "beasty" formula that you see below works well.

AG7,AN7="AC Initiated")),IF(AND(TODAY()>AG7,AN7="AC Initiated"),IF(AP7="","Check AC Status",IF(AND(TODAY()>EDATE(AP7,6),AN7="AC Initiated"),"Re-Check AC Status","")),IF(AND(TODAY()>EDATE(AA7,12),AN7="Referred to TX"),IF(AL7="","Eval Before RF",

The string below (which attaches to my "beasty" formula above) has been
separated out from the above formula for the purpose of clarity in this
posting.

It seems to work appropriately (creating the Confirm AC Follow Through Flag)
ONLY when a date is input into cell AA7. However, the string of formula below
should ALSO "register" and produce the applicable flag (Confirm AC Follow
Through), when a date input into cell AL7 (and NO date is placed in cell AA7).

IF(AND(TODAY()>EDATE(AL7,6),AN7="Referred to Tx"),"Confirm AC Follow
Through","")),"")),

This last string of the formula (which comes after that which you see
above) does work, and flags according to the logic.

IF(AL7<>"",IF(AND(TODAY()>EDATE(AL7,12),AN7="Referred to Tx"),"New Eval
Needed",""),"")))

So now that I almost have it, any final suggestions to tame this beast? I
suspect that I need to add in one more piece of logic in order for the
formula to work 100%. Again, it is only the string I pointed out (under the
single condition mentioned) that doesn't seem to want to play

Thanks very much for any help offered!
HAPPY 4th of July all!

Dan

 

[Harlan Grove]

It seems to work appropriately (creating the Confirm AC Follow Through
Flag)
ONLY when a date is input into cell AA7. However, the string of formula
below
should ALSO "register" and produce the applicable flag (Confirm AC Follow
Through), when a date input into cell AL7 (and NO date is placed in cell
AA7).

IF(AND(TODAY()>EDATE(AL7,6),AN7="Referred to Tx"),
"Confirm AC Follow Through","")),"")),

....

Perhaps, but the logic of your formula is tortured. There are only 3
relevant states for AN7: "Referred to Tx", "AC Initiated" and anything else.
That should be your MAIN decision variable. It's difficult to figure out
what conditions need to change before you rearrange your formula around
these 3 base states.