using Excel Solver

K

Kenneth

From A1 to A100, i got value from 1 to 100 (A1 will be value 1, A2 will be
value 2 and so on).

how do i get excel solver to choose for me cells that can possibly add up to
a value of 22?
 
B

Bernard Liengme

Put 1 in each cell in B1:B100
In C1 enter =SUMPRODUCT(A1:A100,B1:B100)
Solver:
Target C1; Value 22
By changing B1:B100
Constraint B1:B100 binary
Solve
There can be many answers, Solver gives one that depends on initial state
best wishes
 
D

Dana DeLouis

There can be many answers, Solver gives one that depends on initial state
best wishes
Click to expand...

Just to mention...combination theory says there are 89 Solutions to this
particular problem.
 
K

Kenneth

thanks a lot! :)

Bernard Liengme said:
Put 1 in each cell in B1:B100
In C1 enter =SUMPRODUCT(A1:A100,B1:B100)
Solver:
Target C1; Value 22
By changing B1:B100
Constraint B1:B100 binary
Solve
There can be many answers, Solver gives one that depends on initial state
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Help creating a macro that will run Solver? 3
Solver Ignores Constraints 1
Solver or not Solver 4
Solver not found 1
Solver won't open 1
SOLVER does not iterate / work 4
Solver Error - an unexpected internal error has occurred 1
Solver 3

Top