Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-10-2015, 11:08 AM
mbking mbking is offline Need formula to determine minimum quantity needed per price Windows 8 Need formula to determine minimum quantity needed per price Office 2007
Novice
Need formula to determine minimum quantity needed per price
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated Formula Needed midgetmogalle Excel 14 01-29-2014 10:26 AM
Need formula to determine minimum quantity needed per price Formula help needed Cosmo Excel 1 08-23-2012 11:50 AM
Need formula to determine minimum quantity needed per price 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft