This is my first attempt at Excel's solver.
Is there a way for solver to give me ALL the possible solutions that fulfill the problem requirements?
AND even better, can it tell me how many solutions are there?
Here is a simplified version of my problem
A + B = X
Set Objective "X" to Value of 4
by changing variables "A" & "B" if A & B are integers > 0
Obviously the solutions are:
1+3
2+2
3+1
What I would like solver to tell me is:
- There are 3 possible solutions
- The solutions are: (1,3) (2,2) and (3,1)
Bookmarks