Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sliding Scale
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sliding Scale
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sliding Scale
Can anyone help me with an example of how to use this function
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sliding Scale
hi Cory,
Here is an example: http://www.kellogg.northwestern.edu/...xcelSolver.pdf -- isabelle Le 2012-01-29 22:56, Cory Tilton a écrit : Can anyone help me with an example of how to use this function |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sliding Scale
Many examples can be found in Excel Help under Solver
Bazillions of on-line hits when you do a search for Excel Solver. Gord On Sun, 29 Jan 2012 19:55:05 -0800 (PST), Cory Tilton wrote: Thanks, Can you give an example of how to use this function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sliding scale Question | Excel Worksheet Functions | |||
Calculate Sliding Scale Calculation | New Users to Excel | |||
Calculating a sliding scale | Excel Worksheet Functions | |||
Sliding Scale Percentage via IF? | New Users to Excel | |||
Division on a sliding scale | Excel Programming |