Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am putting together an estimating program for material. In this case
for steel sheet. The sheet will be cut into strips of a set width and length. I can get x parts from a strip. I want to be able to enter a number of pieces in a cell and have another compute the number of strips I'll need to meet that exact amount or exceed it based on using a complete strip. Example: A strip can yield 25 pieces of part 'bracket'. the quantity I need to buy enough strips for 126 pieces or in this case 6 strips. I want to compute that I'll need 6 strips and that the yield of those strips will be 150 pieces. How can I do so? Many thanks, Rudy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need a formula to sum no of times item no is used and sum up total quantity! | Excel Worksheet Functions | |||
Creating a name list from if quantity value is in adjacent cell on | Excel Worksheet Functions | |||
Formula help with ordering quantity | Excel Worksheet Functions | |||
Can I add a quantity to every cell in a column using a formula? | Excel Discussion (Misc queries) | |||
How do I make the X-Axis increase in scale with the quantity? | Charts and Charting in Excel |