Problem: I can't figure out how to setup Solver to try and attempt to come up with a solution.
Objective: Get D11 as close to 0.000 as possible.
Variable cells: E11:E40
Constraints:
E11:E40 <=10
E11:E40 >= 1
E11:E40 = integer
The easy solution on my worksheet is to change E34 to 4 and E35 to 5. This would make D11 0.000. However, the long term goal is that cells F11:F40 will have random dollar amounts and I'll want excel to distribute numbers 1-10 to E11:E40 to make the percentage distribution to each number as close to their assigned percentages as possible.. which the closer Solver gets, the closer to 0.0000 D11 will be. See screenshot here of my solver setup: TdbYXOw.jpg
Any help on this is much appreciate. Thank you for your help.
Bookmarks