Log In
Register
Home
New Member
November 16, 2021
Offline
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
September 9, 2020
Offline
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
New Member
November 16, 2021
Offline
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?
1 Guest(s)
