Multiple or Variable cell references in Solver (Excel 97)

C

Coreyhotlin

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?
 
B

bpeltzer

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.
 
Top