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

Occasional Visitor

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

 

KimWatkins_2-1657297007899.png

 

KimWatkins_3-1657297035364.png

 

1 Reply

@KimWatkins 

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 

=SUM(M22:M28)

in cell M29.

solver parameter.JPGsolver solution.JPG