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?

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?