Graeme -
The first thing I would check to debug the model is to verify that the
target cell value (and the constraint formula cell value) changes when you
manually enter various values into the changing cells.
- Mike
www.mikemiddleton.com
"Graeme" wrote in message
...
I tried to use 'Guidelines for designing a model to find values with
Solver',
to experiment with the model, but Solver returned the same values as
original
$10,000 per quarter for Advertising. Target cell is $F$7, Constrained
cell
is $F$5 = $40000, Adjustable cells are $B$5:$E$5. What am I doing wrong?