+ Reply to Thread
Results 1 to 2 of 2

Need help with sliding scale compensation formula

  1. #1
    Registered User
    Join Date
    06-22-2011
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Need help with sliding scale compensation formula

    Need to create an excel formula to calculate bonus based on a percent of revenue. Here is what I am looking to do in "pseudo-code":

    Revenue
    $0 - $500,000 - bonus = x% of revenue
    $500,000 - $1,000,000 - bonus = y% of revenue
    $1,000,000 - $1,500,000 - bonus = z% of revenue
    and so on....

    The tricky part is that while this is a tiered scale, it still needs to continually calculate revenue to date. Example, the company does $1,250,000 in revenue. The calculation would be something like:

    The first $500K in revenue is bonused at x%, the second $500K is bonused at y% and the last $250K is bonused at z percent.

    Any help will be greatly appreciated.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Need help with sliding scale compensation formula

    Welcome to the Forum!

    This is very similar to US marginal tax brackets. See attached.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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