PDA

View Full Version : Nesting Complex IF Statements



tucker
11-23-2011, 07:08 AM
I could really use a big hand and any help is much appreciated. I'm just not proficient enough to nest all of theses statements into a single, concise statement that would live in cell G24. Thanks so much!


=IF(AND(OR(H38={"Canvas","Gallery Wrap Canvas","Giclee","Reg Photo Paper","Matte Photo Poster","Moab","Full Bleed Giclee"}),G28=6,G29="11pm"),G26+3,"0")

=IF(AND(OR(H38={"Canvas","Gallery Wrap Canvas","Giclee","Reg Photo Paper","Matte Photo Poster","Moab","Full Bleed Giclee"}),G28=7),G26+2,"0")

=IF(AND(OR(H38={"Laminate","Premium Photo Paper","Wall Decal","Watercolor Paper","Watercolor Paper LE"}),G28=4,G29="11pm"),G26+6,"Ok")

=IF(AND(OR(H38={"Laminate","Premium Photo Paper","Wall Decal","Watercolor Paper","Watercolor Paper LE"}),G28=5,G29="11pm"),G26+6,"Ok")

=IF(AND(OR(H38={"Laminate","Premium Photo Paper","Wall Decal","Watercolor Paper","Watercolor Paper LE"}),G28=6,G29="11pm"),G26+6,"0")

=IF(AND(OR(H38={"Laminate","Premium Photo Paper","Wall Decal","Watercolor Paper","Watercolor Paper LE"}),OR(G28={7}),OR(G29={"3am","7am","11am","3pm","7pm"})),G25+4,"0")

=IF(AND(OR(H38={"Canvas","Gallery Wrap Canvas","Giclee","Reg Photo Paper","Matte Photo Poster","Moab","Full Bleed Giclee"}),OR(G28={1,2,3,4,5,6}),OR(G29={"3am","7am","11am","3pm","7pm"})),G25+1,"0")

=IF(AND(OR(H38={"Canvas","Gallery Wrap Canvas","Giclee","Reg Photo Paper","Matte Photo Poster","Moab","Full Bleed Giclee"}),OR(G28={1,2,3,4,5}),OR(G29="11pm")),G25+2,"0")

=IF(AND(OR(H38={"Laminate","Premium Photo Paper","Wall Decal","Watercolor Paper","Watercolor Paper LE"}),OR(G28={1,2,3,4}),OR(G29={"3am","7am","11am","3pm","7pm"})),G25+3,"0")

=IF(AND(OR(H38={"Laminate","Premium Photo Paper","Wall Decal","Watercolor Paper","Watercolor Paper LE"}),OR(G28={1,2,3,7}),OR(G29="11pm")),G25+4,"0")

=IF(AND(OR(H38={"Laminate","Premium Photo Paper","Wall Decal","Watercolor Paper","Watercolor Paper LE"}),OR(G28={6}),OR(G29={"3am","7am","11am","3pm","7pm"})),G25+5,"0")

=IF(AND(OR(H38={"Laminate","Premium Photo Paper","Wall Decal","Watercolor Paper","Watercolor Paper LE"}),OR(G28={5}),OR(G29={"3am","7am","11am","3pm","7pm"})),G25+5,"0")

arthurbr
11-23-2011, 09:30 AM
Cross post at excelforum.com

tucker
11-23-2011, 09:34 AM
Tell me how to delete this post and I'll take it down.

Cross posted at http://www.excelforum.com/excel-general/802796-nesting-complex-if-statements.html