using Excel Solver

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kenneth - 24 Mar 2008 10:16 GMT

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?

Reply to this Message

Jarek Kujawa - 24 Mar 2008 10:23 GMT

would you expand?

how many cells?

Reply to this Message

Bernard Liengme - 24 Mar 2008 12:56 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

> 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?

Reply to this Message

Dana DeLouis - 24 Mar 2008 15:23 GMT

> There can be many answers, Solver gives one that depends on initial state
> best wishes

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

Signature

Dana DeLouis

> Put 1 in each cell in B1:B100
> In C1 enter =SUMPRODUCT(A1:A100,B1:B100)
[quoted text clipped - 12 lines]
>> to
>> a value of 22?

Reply to this Message

Kenneth - 25 Mar 2008 02:02 GMT

thanks a lot! (:

> Put 1 in each cell in B1:B100
> In C1 enter =SUMPRODUCT(A1:A100,B1:B100)
[quoted text clipped - 11 lines]
> > to
> > a value of 22?

Reply to this Message