Nesting Complex IF Statements

[tucker]

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!


[VBA]=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")[/VBA]

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

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

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

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

[VBA]=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")[/VBA]

[VBA]=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"})),G 25+1,"0")[/VBA]

[VBA]=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")[/VBA]

[VBA]=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" )[/VBA]

[VBA]=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")[/VBA]

[VBA]=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")[/VBA]

[VBA]=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")[/VBA]

[arthurbr]

Cross post at excelforum.com

[tucker]

Tell me how to delete this post and I'll take it down.

Cross posted at http://www.excelforum.com/excel-gene...tatements.html