I have a spreadsheet that calculates the amount of board needed in order to run multiple orders using the same components. The yellow fields will be input fields for the user, the purple fields will be titles that do not change, and the white fields will be the displayed calculations. This is a more advanced version of a spreadsheet I did for single orders (floodcoat workup_single). I have two versions of what I am trying to do now, but I can’t get the math to work right. The spreadsheet I want to be using is “Floodcoat Workup_Combos_LGC_12-15-15.” Long story short, column U calculates how many component pieces will be required to run all units. Column F displays how many pieces can fit on one sheet to be die cut. This should be a simple math formula (=U6/F6) to get the Total Sheets REQ (Column E), but each time I do this and drag the formula down I get the #DIV error message displayed for items with input data. I would also like Column V to calculate the total MSF for each order (should be Total Sheets REQ * Sq Ft. or Column E * H) and not display errors messages as well. Lastly, V50/51 should look at the 10% marked-up total from V49 and display the correct cost by looking at the INDEX, which I have working in the other two spreadsheets. However, with the error messages it won’t work. Any help would be much appreciated and I am willing to share more information if needed.

Attached Files

	Floodcoat Workup_Combos_LGC_12-15-15.xlsx (40.6 KB, 10 views)
	floodcoat workup_single.xlsx (19.5 KB, 7 views)
	Floodcoat Workup_Combos.xlsx (39.4 KB, 6 views)

I am not at all sure I understand, but you might want to take a look at the attached.

Attached Files

Floodcoat Workup_Combos_LGC_12-15-15_2.xlsx (39.4 KB, 8 views)

Yes. That works perfectly for Column V. However, for Column E I am essentially needing it to take Column U and divide it by Column E, but I can’t figure out how to do this with an “IF” statement so that I don’t get #DIV error messages where there is not input data. See attached. Thank you for helping too.

Attached Files

Copy of Floodcoat Workup_Combos_LGC_12-15-15_2.xlsx (39.3 KB, 7 views)

Like this:

Attached Files

Floodcoat Workup_Combos_LGC_12-15-15_3.xlsx (39.4 KB, 8 views)

This is good, but I can't get cell V51/52 to pull-up the correct price when it references the cell above it. According to my chart on the upper right 200,000 - 500,000 should be $91, but no matter what I do I keep getting $87. Thank you.

Attached Files

Floodcoat Workup_Combos.xlsx (39.3 KB, 8 views)

Maybe like this:

Attached Files

Floodcoat Workup_Combos_2.xlsx (39.4 KB, 8 views)

Exactly like that! Thank you. I think this has me covered.

I am kinda new to these forums. Is there something I can do to give you recognition or close out the forum?

You can give xor rep. Click on the little scale in one of his/her posts, and click " add reputation". Add some comment if needed

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post