1. Registered User
Join Date
Jan 2007
Posts
2

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. Registered User
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?

3. Registered User
Join Date
Jan 2007
Posts
2
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. Registered User
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.

#### Posting Permissions

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