+ Reply to Thread
Results 1 to 6 of 6

calculate 4 different tiers of commission with fix salary

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    2

    calculate 4 different tiers of commission with fix salary

    Hi everyone , i need some help to calculate 4 different tiers of commission with fix salary.

    1ST tier: less than $6,000 ( receive fix salary of $2000)
    2Nd tier: $6001 to $10,000 ( X25% )
    3RD: $10,000 - $14,000 ( 30%)
    4TH: $14,000 and above ( 35% )

    All sales will take off $6,000 from the base sales.Commission will overlap once sales surpass 1ST tier.

    E.G:
    Sales: $12,000
    Commission: $12,000- $6,000= $6,000
    $6,000 X 30%

    Total:$2,000 ( fixed salary ) + $1,800 ( commision ) = $3,800

    Please help!! thanks
    Last edited by vlady; 06-05-2014 at 07:13 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: calculate 4 different tiers of commission with fix salary

    Try this
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

  3. #3
    Registered User
    Join Date
    06-04-2014
    Posts
    2

    Re: calculate 4 different tiers of commission with fix salary

    Hi there, thanks for your help. i have tried this formula but it couldnt calculate for the 2nd tier, 3rd and 4th tiers. please advice thanks

  4. #4
    Forum Contributor
    Join Date
    11-11-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: calculate 4 different tiers of commission with fix salary

    Try this

    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: calculate 4 different tiers of commission with fix salary

    Post a workbook showing me what you mean. Put the sale and the result it should be and what my formula is producing so I can see what went wrong.

    Edit: wait, I see missing parentheses. That's what happens when I'm trying to write formulas from my head instead of using a sample workbook. Try this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by k64; 06-08-2014 at 12:08 AM.

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,617

    Re: calculate 4 different tiers of commission with fix salary

    Pl see attached file with formula.
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 06-08-2014 at 01:26 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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