Excel Solver not finding a feasible solution when there is one.

Copper Contributor

I am trying to use the Solver tool to find multiple amounts that equal a specific amount. This worked one time for me and now I can never get Solver to find a solution, when I know there is one.  In the screenshot, the highlighted amounts equal the sum of the amount I am looking for, but when I run solver it says there is no solution. What am I doing wrong??






1 Reply


Are you looking for value 21.452,07 in cell J34? I've changed the target value in the solver parameters and it works in my sheet. In the sheet there are a few formulas for example 


in cell M29.

solver parameter.JPGsolver solution.JPG