+ Reply to Thread
Results 1 to 2 of 2

Help! Need to calculate bonuses based on years and salary.....

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    Help! Need to calculate bonuses based on years and salary.....

    I am stuck and need some help.

    I have to calculate bonuses for employees using IF statements based on their salary, age (no bonus until 50) and years of employment. I have the table set up as follows:
    Employee Age Length of Service Salary

    <5 = 0 bonus
    5-10 =20%
    11-15=30%
    16-20=40%
    21-25=50%
    26 or more =100% of yearly salary

    I am very stuck and really could use some advise.

    Thank you so much in advance. I am starting to see stars with my frustration.....
    Last edited by larasmomma; 11-26-2012 at 06:04 PM. Reason: small correction

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

    Re: Help! Need to calculate bonuses based on years and salary.....

    Try

    =LOOKUP(A1,{0,5,11,16,21,26},{0,20%,30%,40%,50%,100%})

    Also your data is wrong 20 years service, is that 40% or 50% cos 20 is listed against BOTH percentages (I've assumed 20 is 40%)
    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.

+ 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