Results 1 to 4 of 4

Thread: Formulas

  1. #1
    Join Date
    Jan 2007
    Posts
    2

    Unanswered: Formulas

    Hi. I am a novice when it comes to using Formulas in Excel so help would be very much appreciated.
    I am trying to organise an Earnings Calculator for my employees to help calculate the amount of annual bonuses available to them.
    For example:
    from 80% of their target of $200,000 up to $350,000, a bonus of 2% will be given.
    or
    if cell G7 minimum $200,000 or equal to $350,000 then 2% bonus applies to that figure.

    And another:
    if cell G7 is up to 90% of cell A2 then $700 applies

    Help!!

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy, and welcome. So, how many conditions do you have? Just these three? Or is there more? If more, you might need to set up a lookup table. Can you provide the limits of the dollar values in cells?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2007
    Posts
    2
    Hi. Thanks for the reply.
    There are up to 10 different bonus opportunities, but once I am shown the correct format for these two, I should be able to adapt it for each other one.

    More details of the ones already mentioned are:
    1)
    From 80% of target to $393750 - 2% bonus
    From 80% of target, min $393751 to $493750 - 3% bonus
    From 80% of target, min $493751 to $593750 - 4% bonus
    and so on

    2)
    90% of target achied - $700
    100% - $1260
    110% - $1740
    120% - 2360
    and so on

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    With that many, it might be best to set up a lookup table and use that as the basis for determining the bonus.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •