Multiple or Variable cell references in Solver (Excel 97)
 

I'm using solver to find the optimal price by returning a margin of 0.
Because I need to repeat this for several hundred prices, I have been trying
to use either an unfixed target cell reference, or alternatively use a range
of target cells (e.g. a column). It won't let me do either of these. Is this
something that is addressed in later versions of Excel, or is there another
solution you can suggest?

Multiple or Variable cell references in Solver (Excel 97)
 

If you need a range of cells all to wind up with a value of 0, you could
create a helper column equal to the absolute value of a real target
(=abs(a1), for instance), create one cell that's the sum, and tell solver to
force that cell to 0.

"Coreyhotlin" wrote:

I'm using solver to find the optimal price by returning a margin of 0.
Because I need to repeat this for several hundred prices, I have been trying
to use either an unfixed target cell reference, or alternatively use a range
of target cells (e.g. a column). It won't let me do either of these. Is this
something that is addressed in later versions of Excel, or is there another
solution you can suggest?