+ Reply to Thread
Results 1 to 4 of 4

Multiply Differential slabs with differential rates

  1. #1
    Forum Contributor
    Join Date
    12-11-2014
    Location
    dubai
    MS-Off Ver
    2010
    Posts
    142

    Multiply Differential slabs with differential rates

    Hi All

    Slab 0-25 25-50 50-100 >101
    Incentive 10 20 30 40

    I have above slab and incentive Structure.

    I have different person who will sell different quantities.
    Supposingly if i have one person whos sold 120, the following steps i follow to arrive at incentive.

    First 25 units, 25*10$
    25-50 units, 25*20$
    50-100 units , 50*30$
    >100, 19*40

    Total Result 3010
    How to formulate this.
    Any help will be greatly appreciated.

    Thanks

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Multiply Differential slabs with differential rates

    Google Tiered commission or have a look here for similar

    http://www.mrexcel.com/forum/excel-q...formula-2.html
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: Multiply Differential slabs with differential rates

    I think that solution should actually be 3050, as the last step would be 20*40. Here is a formula that gets that result:
    Please Login or Register  to view this content.
    Here is a file that shows a possible setup, the slabs are set up in A2:B5 and the incentives are in C2:C5 Bin Based Calculations.xlsx
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Multiply Differential slabs with differential rates

    I also think that the answer to the question posed should by 3050 after manually verifying my results. Enter this where you need the result given that the value entered is in B1.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The values 250, 750, 2250 are the totals as the range limits are passed. Eg if the value is 30 then the limit for the first range (0-25) has been passed and the value accumulated is 250. To this is added the amount in the next range etc.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] Differential Pay
    By bobanderson123 in forum Excel General
    Replies: 10
    Last Post: 03-10-2022, 07:40 PM
  2. Differential equations in VBA
    By Amelia_T in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2014, 09:44 PM
  3. How to calculate Night Differential
    By mar_t in forum Excel General
    Replies: 10
    Last Post: 01-04-2013, 01:55 AM
  4. Timesheet Differential Trauma..
    By [DarkGUNMAN] in forum Excel General
    Replies: 0
    Last Post: 11-16-2011, 08:16 AM
  5. Horizontal Axis Differential Formatting
    By BRISBANEBOB in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 03-22-2010, 08:19 PM
  6. Help with differential equation
    By raaymaan in forum Excel General
    Replies: 0
    Last Post: 03-13-2010, 09:59 AM
  7. shift differential
    By flyeaglesfly in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2008, 04:09 PM

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