Hi

While there is only one target cell, you can use the
constraints to effectively have other target cells. Say
you want A1 to be 10, then set this as the target cell.
If you want B1 to be 13, and C1 to be 14, then include
them in the constraints.


HTH

Tony
-----Original Message-----
Hi,

For those who have worked with Solver in excel.
I was wondering if there is a version of this add-in , or
may be some
other add-ins to do the same sort of problem solving, but
to accept
more than one target cell. To maximize/minimize the
target cell. I
would like to have some cells change, to give me the
minimum amount on
4 values for example. Solver is great, but it only
accepts one value
for the target.

Thanks for the comments.


---
Message posted from http://www.ExcelForum.com/

.