Help with filling information from multiple cells with an overly large if equation

Hey Folks.

I am still pretty new with Excel. Its been years since I have actually used it to for its true purpose. Anyways if this is a dumb question I am truly sorry.

I have a equation that i feel has to be simplified due in part to the fact that I can't even use the whole thing I have to split it into 2 cells.

Here is the formula:
Cell 1:
=('Calculation Inputs'!A2)*
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A8)-1)),'Calculation Inputs'!B7,
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A9)-1)),'Calculation Inputs'!B8,
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A10)-1)),'Calculation Inputs'!B9,
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A11)-1)),'Calculation Inputs'!B10,
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A12)-1)),'Calculation Inputs'!B11,
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A13)-1)),'Calculation Inputs'!B12,
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A14)-1)),'Calculation Inputs'!B13,
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A15)-1)),'Calculation Inputs'!B14,
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A16)-1)),'Calculation Inputs'!B15,
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A17)-1)),'Calculation Inputs'!B16,
(IF(AND(Main!E15=1,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!B17,
(IF(AND(E15=1,E17=0,'Calculation Inputs'!A2>(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!B18,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A8)-1)),'Calculation Inputs'!C7,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A9)-1)),'Calculation Inputs'!C8,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A10)-1)),'Calculation Inputs'!C9,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A11)-1)),'Calculation Inputs'!C10,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A12)-1)),'Calculation Inputs'!C11,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A13)-1)),'Calculation Inputs'!C12,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A14)-1)),'Calculation Inputs'!C13,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A15)-1)),'Calculation Inputs'!C14,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A16)-1)),'Calculation Inputs'!C15,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A17)-1)),'Calculation Inputs'!C16,
(IF(AND(Main!E15=1,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!C17,
(IF(AND(E15=1,E17=1,'Calculation Inputs'!A2>(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!C18,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A8)-1)),'Calculation Inputs'!D7,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A9)-1)),'Calculation Inputs'!D8,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A10)-1)),'Calculation Inputs'!D9,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A11)-1)),'Calculation Inputs'!D10,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A12)-1)),'Calculation Inputs'!D11,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A13)-1)),'Calculation Inputs'!D12,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A14)-1)),'Calculation Inputs'!D13,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A15)-1)),'Calculation Inputs'!D14,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A16)-1)),'Calculation Inputs'!D15,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A17)-1)),'Calculation Inputs'!D16,
(IF(AND(Main!E15=2,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!D17,
(IF(AND(E15=2,E17=0,'Calculation Inputs'!A2>(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!D18,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A8)-1)),'Calculation Inputs'!G7,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A9)-1)),'Calculation Inputs'!G8,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A10)-1)),'Calculation Inputs'!G9,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A11)-1)),'Calculation Inputs'!G10,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A12)-1)),'Calculation Inputs'!G11,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A13)-1)),'Calculation Inputs'!G12,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A14)-1)),'Calculation Inputs'!G13,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A15)-1)),'Calculation Inputs'!G14,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A16)-1)),'Calculation Inputs'!G15,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A17)-1)),'Calculation Inputs'!G16,
(IF(AND(Main!E15=2,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!G17,
(IF(AND(E15=2,E17=1,'Calculation Inputs'!A2>(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!G18,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A8)-1)),'Calculation Inputs'!F7,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A9)-1)),'Calculation Inputs'!F8,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A10)-1)),'Calculation Inputs'!F9,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A11)-1)),'Calculation Inputs'!F10,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A12)-1)),'Calculation Inputs'!F11,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A13)-1)),'Calculation Inputs'!F12,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A14)-1)),'Calculation Inputs'!F13,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A15)-1)),'Calculation Inputs'!F14,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A16)-1)),'Calculation Inputs'!F15,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A17)-1)),'Calculation Inputs'!F16,
(IF(AND(Main!E15=2,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!F17,
(IF(AND(E15=2,E17=2,'Calculation Inputs'!A2>(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!F18,0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Cell 2 to follow in comment.

As you can see its way too long. Here is what it does

It looks at the number of colors you would like to have on the front and back of a shirt and the number of shirts you need to order and then looks at a large table with multiple price breaks included in it.

i.e. If 1 color on the back and 1 color on the front and you need 48 shirts the cost is 48 x $3.45 = $165.60

I am hoping I am just limiting myself to the use of if/and statements and that there is a better way to do this. .

Thank you all ahead of time.

Cell 2:
=('Calculation Inputs'!A2)*
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A8)-1)),'Calculation Inputs'!G7,
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A9)-1)),'Calculation Inputs'!G8,
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A10)-1)),'Calculation Inputs'!G9,
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A11)-1)),'Calculation Inputs'!G10,
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A12)-1)),'Calculation Inputs'!G11,
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A13)-1)),'Calculation Inputs'!G12,
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A14)-1)),'Calculation Inputs'!G13,
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A15)-1)),'Calculation Inputs'!G14,
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A16)-1)),'Calculation Inputs'!G15,
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A17)-1)),'Calculation Inputs'!G16,
(IF(AND(Main!E15=3,Main!E17=0,'Calculation Inputs'!A2<(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!G17,
(IF(AND(E15=3,E17=0,'Calculation Inputs'!A2>(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!G18,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A8)-1)),'Calculation Inputs'!H7,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A9)-1)),'Calculation Inputs'!H8,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A10)-1)),'Calculation Inputs'!H9,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A11)-1)),'Calculation Inputs'!H10,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A12)-1)),'Calculation Inputs'!H11,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A13)-1)),'Calculation Inputs'!H12,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A14)-1)),'Calculation Inputs'!H13,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A15)-1)),'Calculation Inputs'!H14,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A16)-1)),'Calculation Inputs'!H15,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A17)-1)),'Calculation Inputs'!H16,
(IF(AND(Main!E15=3,Main!E17=1,'Calculation Inputs'!A2<(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!H17,
(IF(AND(E15=3,E17=1,'Calculation Inputs'!A2>(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!H18,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A8)-1)),'Calculation Inputs'!I7,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A9)-1)),'Calculation Inputs'!I8,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A10)-1)),'Calculation Inputs'!I9,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A11)-1)),'Calculation Inputs'!I10,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A12)-1)),'Calculation Inputs'!I11,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A13)-1)),'Calculation Inputs'!I12,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A14)-1)),'Calculation Inputs'!I13,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A15)-1)),'Calculation Inputs'!I14,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A16)-1)),'Calculation Inputs'!I15,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A17)-1)),'Calculation Inputs'!I16,
(IF(AND(Main!E15=3,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!I17,
(IF(AND(E15=3,E17=0,'Calculation Inputs'!A2>(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!I18,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A8)-1)),'Calculation Inputs'!J7,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A9)-1)),'Calculation Inputs'!J8,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A10)-1)),'Calculation Inputs'!J9,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A11)-1)),'Calculation Inputs'!J10,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A12)-1)),'Calculation Inputs'!J11,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A13)-1)),'Calculation Inputs'!J12,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A14)-1)),'Calculation Inputs'!J13,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A15)-1)),'Calculation Inputs'!J14,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A16)-1)),'Calculation Inputs'!J15,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A17)-1)),'Calculation Inputs'!J16,
(IF(AND(Main!E15=3,Main!E17=3,'Calculation Inputs'!A2<(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!J17,
(IF(AND(E15=3,E17=3,'Calculation Inputs'!A2>(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!J18,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A8)-1)),'Calculation Inputs'!K7,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A9)-1)),'Calculation Inputs'!K8,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A10)-1)),'Calculation Inputs'!K9,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A11)-1)),'Calculation Inputs'!K10,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A12)-1)),'Calculation Inputs'!K11,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A13)-1)),'Calculation Inputs'!K12,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A14)-1)),'Calculation Inputs'!K13,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A15)-1)),'Calculation Inputs'!K14,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A16)-1)),'Calculation Inputs'!K15,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A17)-1)),'Calculation Inputs'!K16,
(IF(AND(Main!E15=4,Main!E17=2,'Calculation Inputs'!A2<(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!K17,
(IF(AND(E15=4,E17=2,'Calculation Inputs'!A2>(('Calculation Inputs'!A18)-1)),'Calculation Inputs'!K18,))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))