Andrew,

Your formula does work but only if the total quantity available to ship is
greater than the quantity needed. If, as in the example I gave, the quantity
available (700 pcs) is less than the quantity needed (1000 pcs), the formula
result is 0 (zero). In this instance the answer should be 2 because 2 is the
total number of containers available even though the quantity is less than
what is needed.

And don't give a second thought about the time. I wasn't working yesterday.

Thanks,

Ron

"loudfish" wrote:

On 18 May, 20:50, ronnomad wrote:
Sorry, I guess because I know what I want, I not being clear enough. If for
the first item I need 1000 pcs but I only have 700 pieces in two containers,
the formula answer ( for that row) should be two. I rarely (if ever) send 24
containers of one item. The shipment is a combination.


Sorry for delay. I still don't get your requirements - can you give me
a more explanatory example?

The formula, as it stands, will give you the number of containers
required (not the number of pcs) to fulfil each particular request.

e.g. 700 in container 1, 700 in container 2, requirement is for 1000
pcs, therefore answer is 2 (more explicitly, answer is 700 from
container 1 plus 300 from container 2). The formula I already gave
should return 2 in this case.

Andrew