Nesting IF Statement

Cross posted at http://www.vbaexpress.com/forum/show...135#post255149



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.

=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")