Multipl IF Statements - REVISION
 

Forgot to mention...
I am creating a spreadsheet that managers will use to input a single piece
of data - Actual Gross Profit. Based on that one entry, I need one formula to
calculate the bonus based on the following:

To receive a bonus, Gross Profit must be at least $250,000
Once minimum is met, bonuses are calculated as a percent of the Adjusted GP
(GP minus $250,000) as follows:

If Actual GP is under $500,000:
3% of Adjusted GP

If Actual GP is $500,000 up to $750,000:
3% of first $250,000
4% of balance of Adjusted GP

If Actual GP is over $750,000:
3% of first $250,000
4% of second $250,000
4.5% of balance of Adjusted GP

Thanks!!

-----Original Message-----
Forgot to mention...
I am creating a spreadsheet that managers will use to
input a single piece
of data - Actual Gross Profit. Based on that one entry, I
need one formula to
calculate the bonus based on the following:

To receive a bonus, Gross Profit must be at least $250,000
Once minimum is met, bonuses are calculated as a percent
of the Adjusted GP
(GP minus $250,000) as follows:

If Actual GP is under $500,000:
3% of Adjusted GP

If Actual GP is $500,000 up to $750,000:
3% of first $250,000
4% of balance of Adjusted GP

If Actual GP is over $750,000:
3% of first $250,000
4% of second $250,000
4.5% of balance of Adjusted GP

Thanks!!
.


lol

they can pay these huge bonuses but they can't figure out
how to calculate just how much that well deserved bonus is

how much bonus will i get for an answer