Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I create fee structured sliding scale?

I need a sliding scale with formulas created to be both functional and aesthetic.

The parameters a

For incomes $50,000 and below in $10,000 increments

From 1 - 3 dependents

To be structured around two services fees: $4,500 and $5,500




Submitted via EggHeadCafe - Software Developer Portal of Choice
Create Function in SQL Server
http://www.eggheadcafe.com/tutorials...in-sql-se.aspx
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How do I create fee structured sliding scale?

You didn't specify the relationships. But it looks stepped, not sliding
with 15 values, with the bottom 4,500 and the top at 5,500 with 13
values in-between.

Lisa wrote:
I need a sliding scale with formulas created to be both functional and aesthetic.

The parameters a

For incomes $50,000 and below in $10,000 increments

From 1 - 3 dependents

To be structured around two services fees: $4,500 and $5,500




Submitted via EggHeadCafe - Software Developer Portal of Choice
Create Function in SQL Server
http://www.eggheadcafe.com/tutorials...in-sql-se.aspx


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
Sliding scale Question Sandy Excel Worksheet Functions 1 April 14th 07 12:28 PM
Calculate Sliding Scale Calculation Andy New Users to Excel 1 March 13th 07 06:02 PM
Calculating a sliding scale John Excel Worksheet Functions 3 February 13th 07 05:16 PM
Sliding Scale Percentage via IF? JadewindFalcon New Users to Excel 4 September 22nd 06 11:58 PM
Percentage Commission on a sliding scale. JonPFP Excel Discussion (Misc queries) 6 April 13th 06 06:24 PM


All times are GMT +1. The time now is 06:51 AM.

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"