#1




Formula Help for Dividing Properly
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_121515.” 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% markedup 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.

#2




Formula Help for Dividing Properly
I am not at all sure I understand, but you might want to take a look at the attached.

#3




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.

#4




Like this:

#5




This is good, but I can't get cell V51/52 to pullup 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.

#6




Formula Help for Dividing Properly
Maybe like this:

#7




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

#8




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

#9




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

Tags 
formatting, formula help, index match 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
formula does not work properly  msnarayanan  Excel  2  08122015 12:40 AM 
Dividing an Excel data report into even # of rows  zipp77ez###  Excel  5  12122014 09:00 PM 
Dividing merge cell into ten equal rectangles for inputing Digit?  aligahk06  Excel  0  05122010 06:56 AM 
Dividing line at top of document?  daviddoria  Word  0  10242009 08:13 AM 
Dividing by 100!  fkaramagi  Excel  2  01302009 02:52 PM 