Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Solver doesn't seem to react

I need some help using solver. I've used it many times before so I'm not sure
what I'm doing wrong here.

Simply put, the equation is as follows:

ax + by = z

x and y are percentage so that x + y is always 1 or 100%.

There are MANY ax + by equations and I am looking to minimize the standard
deviation of the entire dataset by defining x and y.

So the standard deviation cell is my target cell, with the target of
minimum. I want to adjust x and y = 1- x so it changes itself. I defined
constrains as x cannot be less than 0 and greater than 1. I asume linear
model and then click solve.

Nothing happens.... What am I doing wrong? Any help would be greatly
appreciated. Thanks so much.....
Reply
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
How to make a range of cells react to changes in one cell eleonore Excel Worksheet Functions 1 May 20th 09 12:31 AM
Multiple Charts That React to Custom Excel Filters? binar[_2_] Charts and Charting in Excel 0 March 17th 09 02:43 AM
Contitional Formatting - Can I Make One Cell React To A Range? IanC[_2_] Excel Worksheet Functions 1 October 13th 08 10:51 AM
cells react different on 2 computers Dave Excel Worksheet Functions 0 January 23rd 07 02:49 AM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM


All times are GMT +1. The time now is 01:47 PM.

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

About Us

"It's about Microsoft Excel"