Need formula to determine minimum quantity needed per price

[mbking]

I have two columns, for example I'll say one column is boxes of crayons at varying prices. Another column is the suggested minimum quantity that must be purchased. The amount of the two multiplied together must equal greater than 100.



Box of crayons price = $2.35
Suggested minimum quantity = ?
(price times minimum quantity must equal greater than 100, and the minimum quantity number must be the lowest denominator to get to greater than 100)

I hope that makes sense. Thanks for your help.

[gebobs]

MOQ=100/Price

Since MOQ must be integer, MOQINT=ROUNDUP(100/Price,0). This will round up the result to the next integer.

e.g. Price=2.35

MOQ=100/Price=42.55319149
MOQINT=ROUNDUP(100/Price,0)=43

Checking: $2.35*43=$101.45

[mbking]

Thanks! That's perfect!