LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula for commissions on a per piece bases LMM300M Excel Worksheet Functions 1 March 28th 07 01:57 AM
Logic Formula Truc Lopez Excel Worksheet Functions 6 January 4th 07 05:16 PM
Logic formula using Time rkemper Excel Discussion (Misc queries) 4 December 23rd 05 01:47 AM
Adding something to a complicated formula Roz Excel Discussion (Misc queries) 6 December 20th 05 09:00 PM
Complicated adding James W. Excel Worksheet Functions 4 December 21st 04 10:48 PM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"