Hi,
I have four products that each have a different value. I need to calculate how many of each product will meet both a quantity and budget goal.
For example, my four product prices are:
Candle $10
Box $20
Table $15
Light $12
And my goal budget is $38,000
Can i set up a table with a formula that will calculate how many of each will be needed to stay within or meet my goal of $38,000
Hi,
Anything is possible with Excel. But we have too little information to give an answer.
Can you order just one of these items? Can you order a combination of these items? According to what criteria? Twice as many candles as tables? As many candles as lamps?
Could you attach a file with a visualisation of the expected result?
BR,
Lionel
What additional information do you need?
If I have 38,000 and have four products to order, I am wondering if Excel can automatically tell me how many of each product if I have a column with cost?
Hi,
This solution ?
BR,
Lionel
