Sliding Scale

[Cory Tilton]

Is there anyway to make a sliding scale for an instance like this:
Lets say I have a bunch of numbers, lets just say they are insurance
quotes. I want to add a sliding scale with numbers like .80, .85, .
90, .95 to see how ALL the quotes would change if these discounts
were applied OR have the sliding scale attached to only a certain
range of cells so that I could see how prices would differ if I
applied different discount levels to different cells. Basically I want
to manipulate my numbers with the help of a sliding scale. Help please!

 

[Gord Dibben]

Suggest you load the Solver Add-in.

That is its function.


Gord

 

[Cory Tilton]

Suggest you load the Solver Add-in.

That is its function.

Gord

Thanks, Can you give an example of how to use this function?

 

[Cory Tilton]

Can anyone help me with an example of how to use this function

 

[isabelle]

hi Cory,

Here is an example:

http://www.kellogg.northwestern.edu/rc/docs/UsingExcelSolver.pdf


--
isabelle



Le 2012-01-29 22:56, Cory Tilton a écrit :

 

[Gord Dibben]

Many examples can be found in Excel Help under Solver

Bazillions of on-line hits when you do a search for Excel Solver.


Gord