Solver: Return more than one solution?

[cubs610]

Hi everyone.

Question- is it possible to have the solver return more than one solution, without having to (consistently) change the constraints.

For example: X + Y = 10
Current formula 5 + 5 = 10
Solver--> set cell to 10 (the formula answer) by changing X and Y. Constraints, X <=4, Y>= 5.

Given these constraints, you can use (return) a formula like, 3+7, 2+8, 1+9, obviously. So is there any way to have the solver show all the possible solutions (combinations)?

Love to hear your thoughts.

Thanks!
-Dave

 

[Luke M]

You would need to first add more constraints, if it were possible. Right now, XL could also give
-1, 11
-2, 12
-3, 13
5.5, 4.5
5.55, 4.45
5.555, 4.445
...infinity

Here's the closest I could find to a solution of trying to get solver to return x results. (x = 1,2,3, etc)
http://www.pcreview.co.uk/forums/multiple-optimal-solution-using-excel-solver-t1740647.html
http://www.ozgrid.com/forum/showthread.php?t=109964

 

[cubs610]

Hey Luke.... thanks man... definitely appreciate it!

Best,
Dave