Thread
:
Need formula to determine minimum quantity needed per price
View Single Post
02-10-2015, 12:34 PM
gebobs
Windows 7 64bit
Office 2010 64bit
Expert
Join Date: Mar 2014
Location: Atlanta
Posts: 837
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
gebobs
View Public Profile
Find all posts by gebobs