URGENT. Nesting If, AND, OR Statements Solution Needed asap PLEASE!!!

[JohnnyAngel]

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> <o:TargetScreenSize>1024x768</o:TargetScreenSize> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> All,

I'm trying to create this complex IF statement that I think will contain IF, AND, OR Statements. How do I properly piece these together as ONE formula to utilize that will contain all the criteria listed in each argument?

Again, I need to know how I can put ALL 3 criteria listed below in to ONE single long formula. Is this possible?


The criteria for the combine formula should accomplish the following in ONE LONG formula:

1.) IF the value in E2 is "RETL" AND the sum of cells P2:Q2 is >$2000, AND the date in cell T2 is less than March 1, 2011, if true code with "C", if false code with "A".

2.) IF the value in E2 is "WKLY" AND the sum of cells P2:Q2 is >$2000, AND T2 is less than March 1, 2011, if true code with "E", if false code with "D".

3.) IF the value in E2 is "DLY" AND the sum of cells N2:Q2 is >1, AND T2 is less than March 15, 2011, if true code with "E", if false code with "B".


I really appreciate your help on this.

 

[gsistek]

=if(and(sum(p2:q2) > 2000,t2 < date(2011,3,1)),if(e2="retl","c","e"),if(e2="wkly","d",if(and(sum(p2:q2) > 1,t2 < date(2011,3,15)),"e","b")))

 

[jasonb75]

Duplicate thread

http://www.mrexcel.com/forum/showthread.php?t=544429

 

[Peter_SSs]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Guidelines (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.

Also note point 12 in the Guidelins regarding thread titles.