Thread: Sliding Scale
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cory Tilton Cory Tilton is offline
external usenet poster
 
Posts: 3
Default Sliding Scale

On Jan 29, 10:11*pm, Gord Dibben wrote:
Suggest you load the Solver Add-in.

That is its function.

Gord

On Sun, 29 Jan 2012 18:03:15 -0800 (PST), Cory Tilton







wrote:
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!




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