Solver problem keeping new contract money unchaged after changing quantities

Hey everyone!

I am stuck at this simple (I believe it is simple *sighs*) solver problem...

Basically I have a total amount of money in a contract which is cell F23 (37,257,548.96) and I am trying to redistribute some quantities but maintaining the final TOTAL AMOUNT constant.

So I created a very simple solver model that aims to make the difference of the original contract (Cell F23) and the new contract (Cell N23) equal to ZERO. Makes sense right? And the solver should aim at that by changing cell P10 (which is a number that is being added to the quantity of ITEM 9.

I know that if the "changing cell" in solver is 22, the model is solved. But I run the model and it doesn't converge to any answers... and I would assume this would be simple. Clearly I am doing something wrong.

Please help me out!
Thank you!!

Why not use "Goal Seek" instead of solver?

goal_1.jpg

as this will give you the result you wish for.

goal_2.jpg

If you have difficulty in viewing the images right click on an image and select "Open image in new tab"

Alf

But if you really wish to use Solver it seems you have to use the "Evolutionary" solver engine available from Excel 2010 and upwards.

asolv_3.jpg

As you don't specify your Excel version in your user profile I don't know if this is an option you could use.

Alf

Thank you very much Alf!!