+ Reply to Thread
Results 1 to 2 of 2

Sliding scale in Excel 2003 (Difficult)

  1. #1
    Registered User
    Join Date
    08-19-2014
    Location
    USA
    MS-Off Ver
    2003
    Posts
    0

    Sliding scale in Excel 2003 (Difficult)

    Hello,

    I need a sliding scale formula with which I'm having difficulties. Below is the data.

    Anything under $100,000 will get a commission of 10%

    Over $100,000:

    Bracket:

    0-100,000 - 8%
    100,001-500,000 - 6%
    500,001-999,999 - 4%
    1,000,000-3,000,000 - 2%

    Thank you.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello krutrzy77,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. sliding scale?
    By GardenGrow in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 03-30-2014, 08:50 PM
  2. [SOLVED] sliding scale???
    By GardenGrow in forum Excel General
    Replies: 6
    Last Post: 03-29-2014, 01:15 PM
  3. Macro for sliding scale
    By Djinn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2012, 03:45 AM
  4. Replies: 1
    Last Post: 01-04-2012, 03:49 PM
  5. Pricing on a 'sliding scale' possible?
    By Guitarmarky in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-25-2007, 02:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1