Bonus Calculation

jdechamp

New Member
Joined
Dec 21, 2005
Messages
1
I need to calculate bonuses based on the follow criteria:

60,000 - 74,999 earns a bonus of 2%
75,000 - 89,999 earns a bonus of 3%
90,000+ earns a bonus of 6%

The formula needs to indentify the correct bonus and apply it.

I appreciate your help!!!
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
jdechamp said:
I need to calculate bonuses based on the follow criteria:

60,000 - 74,999 earns a bonus of 2%
75,000 - 89,999 earns a bonus of 3%
90,000+ earns a bonus of 6%

The formula needs to indentify the correct bonus and apply it.

I appreciate your help!!!

=A2*LOOKUP(A2,{0,60000,75000,90000},{0.0,0.2,0.3,0.6})
 

Watch MrExcel Video

Forum statistics

Threads
1,118,055
Messages
5,569,948
Members
412,299
Latest member
agentless
Top