+ Reply to Thread
Results 1 to 2 of 2

How to calculate and nonlinear sliding scale

  1. #1
    Registered User
    Join Date
    06-01-2015
    Location
    Norway
    MS-Off Ver
    10
    Posts
    1

    How to calculate and nonlinear sliding scale

    I am trying to calculate the commission % to pay to a sales team based on a increasing % the more they achieve.
    % of Target Bonus as % of Salary
    50% - 0%
    100% - 15%
    200% - 100%
    300% - 200%

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to calculate and nonlinear sliding scale

    Hi and welcome to the forum.

    Check out the VLOOKUP function.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. [SOLVED] sliding scale
    By allgeef in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2014, 12:13 PM
  2. [SOLVED] sliding scale???
    By GardenGrow in forum Excel General
    Replies: 6
    Last Post: 03-29-2014, 01:15 PM
  3. [SOLVED] Formula to calculate commission based on sliding scale
    By Excel Dumbo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2013, 10:52 PM
  4. Calculate Sliding Scale
    By CRC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-27-2012, 12:39 AM
  5. can I calculate S&H on a sliding scale in an order form?
    By TNP in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-01-2005, 02:10 AM

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