#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_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. |
#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 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.
|
#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
__________________
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 |
Tags |
formatting, formula help, index match |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
formula does not work properly | msnarayanan | Excel | 2 | 08-12-2015 12:40 AM |
Dividing an Excel data report into even # of rows | zipp77ez### | Excel | 5 | 12-12-2014 09:00 PM |
Dividing merge cell into ten equal rectangles for inputing Digit? | aligahk06 | Excel | 0 | 05-12-2010 06:56 AM |
Dividing line at top of document? | daviddoria | Word | 0 | 10-24-2009 08:13 AM |
Dividing by 100! | fkaramagi | Excel | 2 | 01-30-2009 02:52 PM |