LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Mike Middleton
 
Posts: n/a
Default



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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver VBA routine KLM Excel Discussion (Misc queries) 4 August 11th 05 11:51 AM
Some Excel links don't work Ben Enfield Excel Discussion (Misc queries) 3 August 2nd 05 12:29 AM
Using solver with function with multiple outputs [email protected] Excel Worksheet Functions 5 July 29th 05 01:58 PM
How to get saved old saved work that was saved over? Maral Excel Discussion (Misc queries) 1 February 20th 05 08:59 PM
Solver "returns no value". Please help Marlon Brown Excel Worksheet Functions 2 February 6th 05 05:25 PM


All times are GMT +1. The time now is 06:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"