I am making a worksheet that will determine the amount of material I
need to buy. Here is the scenario:
I buy the material in stripsthat are 120" long. I can cut out so many
pieces from each strip, which varies from part to part. The material
is steel. I have a cell that allows the user to put in the number of
parts they want to make. Let's say it is 1,000 pcs. The worksheet will
take the number of pieces per sheet and divide the user entry (1,000
pcs) by that number. If the result is less than the 1,000 pcs. due to
a remainder, how can I instruct it to add another strip or more until
the result excedes the user entry and is as close to the entry number
as possible. I cannot be under the user entered amount or I will have
shorted my customer due to not having enough material.

Thank you,

Rudy

Sounds like what you're wanting is ROUNDUP().

And I assume you have something that says part # x = y per strip.

So 1000 pieces would be 1000x

1000x/y = # of strips. Roundup(1000x/y,0) will give total number od strips
needed for 1000 pieces.

"rudyeb" wrote:

I am making a worksheet that will determine the amount of material I
need to buy. Here is the scenario:
I buy the material in stripsthat are 120" long. I can cut out so many
pieces from each strip, which varies from part to part. The material
is steel. I have a cell that allows the user to put in the number of
parts they want to make. Let's say it is 1,000 pcs. The worksheet will
take the number of pieces per sheet and divide the user entry (1,000
pcs) by that number. If the result is less than the 1,000 pcs. due to
a remainder, how can I instruct it to add another strip or more until
the result excedes the user entry and is as close to the entry number
as possible. I cannot be under the user entered amount or I will have
shorted my customer due to not having enough material.

Thank you,

Rudy