EXCEL SOLVER tool

[vito01]

Hi Guys,
I wonder if you can help me please

I am new using EXCEL SOLVER tool and I stuck getting the results I am looking for

I have attached a file so that it is easier to explain

Basically I need to get a result of 200 for each within the range of C30:W30 by changing variable cells C17:W17. I am not sure why but it does not work - is it because I have negative values within the range C18:W25??

Any help would be great!

Thanks

Vito

[Olly]

In this case, I would just use Goal Seek:

Data > What If Analysis > Goal Seek:

Please Login or Register  to view this content.

and repeat for each column.

\1

[vito01]

Thank You!

[Alf]

Solver has at least one advantage compared to GoaloSeek, where GoalSeek solves one cell at a time solver can adjust all cells in one go.

A solver setup as shown in upload will work and in this case you don't need to specify an object cell.

sol_mod.jpg

Alf

[vito01]

Thank You!

[Alf]

You are welcome

Alf