#1
|
|||
|
|||
Need formula to determine minimum quantity needed per price
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks! That's perfect!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complicated Formula Needed | midgetmogalle | Excel | 14 | 01-29-2014 10:26 AM |
Formula help needed | Cosmo | Excel | 1 | 08-23-2012 11:50 AM |
Formula needed to merge 2 name lists into one | lcolson | Excel | 1 | 06-11-2012 12:03 AM |
Very simple formula needed! | nicholes | Excel | 4 | 04-12-2012 08:28 AM |
Excel formula needed. | Rod | Excel | 1 | 08-03-2009 06:55 AM |