Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]() 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solver VBA routine | Excel Discussion (Misc queries) | |||
Some Excel links don't work | Excel Discussion (Misc queries) | |||
Using solver with function with multiple outputs | Excel Worksheet Functions | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
Solver "returns no value". Please help | Excel Worksheet Functions |