View Single Post
 
Old 02-10-2015, 11:08 AM
mbking mbking is offline Windows 8 Office 2007
Novice
 
Join Date: Feb 2015
Posts: 2
mbking is on a distinguished road
Default 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.
Reply With Quote