View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bhaltair
 
Posts: n/a
Default Sliders with more than one variable


Debra Dalgleish Wrote:
If the result cell =1 then the third variable is =1-var1-var2
Make var2 dependent on the slider change
Make var1 =var2*2

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


From what I understand of what you wrote, Varity will always be 2* Var
2, right? I'm trying to change the Values of the variables like this -
Var1+var2+Var+=1
where Var 1 could equal one or .5 or any other number.

Solver has these for the values but I want to learn how to make the
graph with MAD and BIAS graphed as well with sliders for more than just
one variable.

Weighted Moving Ave 1 2 3 Total
α 0.17 0.62 0.21 1


--
Bhaltair
------------------------------------------------------------------------
Bhaltair's Profile: http://www.excelforum.com/member.php...o&userid=30463
View this thread: http://www.excelforum.com/showthread...hreadid=501307