+ Reply to Thread
Results 1 to 2 of 2

Tiered bonus formula

  1. 09-30-2015, 07:46 PM #1
    Dark_Legion
    Dark_Legion is offline
    Registered User
    Join Date
    09-30-2015
    Location
    Lisbon
    MS-Off Ver
    Office 2011
    Posts
    1

    Tiered bonus formula

    Hi, new to Excel, and struggling to find a simple formula for awarding fixed bonuses when sales reach certain values.

    It goes like this:

    SALES - BONUS
    0-75€ - 0€
    75-125€ - 10€
    125-175€ - 20€
    175-225€ - 30€
    225-275€ - 40€
    ... ...
    Last edited by Dark_Legion; 09-30-2015 at 07:48 PM.
    Reply With QuoteRegister To Reply
  2. 09-30-2015, 09:41 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Tiered bonus formula

    you could try this... =LOOKUP(A2,{0,75,125,175,225},{0,10,20,30,40}), it assumes that the values of 0 to 275 are in column A beginning at cell A2.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for calculating a tiered quarterly bonus payout
    By kbroom13 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-28-2015, 06:51 PM
  2. Tiered Bonus (not percentage)
    By pglaeser in forum Excel General
    Replies: 5
    Last Post: 11-17-2014, 04:26 PM
  3. Tiered bonus structure
    By csheils79 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-20-2014, 10:29 AM
  4. Help! Tiered sales/bonus structure...
    By cubby777 in forum Excel General
    Replies: 1
    Last Post: 03-29-2014, 06:21 AM
  5. Need a formula to figure out a pay rate for a tiered bonus program
    By cellinol91 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-24-2013, 10:37 AM
  6. Cumulative Tiered Bonus Structure
    By dpleventhal in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-11-2011, 11:58 AM
  7. Tiered Bonus Structure
    By fwendly in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2009, 04:14 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1