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!!

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?

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

With that many, it might be best to set up a lookup table and use that as the basis for determining the bonus.