Hi Mike
No that resulted in a nonsense answer. Advertising for Q1 went to
-2,147,483,638,000, Q2, Q3 & Q4 advertsing remained 10,000, with Total
advertising -2,147,483,608,000, (constraint $F$5<=40000), and $F$7 result to
2,147,483,751,662

"Mike Middleton" wrote:

Graeme -

If both F7 and F5 are changing in response to changes in each cell of B5:E5,
maybe try F5 <= 40000 instead of F5 = 40000 as the constraint.

- Mike

"Graeme" wrote in message
...
Yes, the values change when entered manually

"Mike Middleton" wrote:

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?