LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Need a formula to increase quantity of one cell until the quantity ofanother is exceeded

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a formula to sum no of times item no is used and sum up total quantity! Amean1 Excel Worksheet Functions 1 June 23rd 07 04:42 PM
Creating a name list from if quantity value is in adjacent cell on Jive Excel Worksheet Functions 4 June 8th 07 01:55 PM
Formula help with ordering quantity Angela Excel Worksheet Functions 8 December 7th 06 04:35 PM
Can I add a quantity to every cell in a column using a formula? Marimar Excel Discussion (Misc queries) 4 July 27th 06 07:00 PM
How do I make the X-Axis increase in scale with the quantity? Leif S Charts and Charting in Excel 1 January 11th 06 04:11 AM


All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"