Employee Bonus Calculation using IF formula...

[ercsearch]

Hi there,

I need to calculate the bonus to be received by an employee who has generated total sales of for example £80,000. The bonus threshold is £50,000 up to which no bonus is receivable (as this covers his basic pay/costs). The bonus scale is 30% for amounts between 50k-75k, 40% for amounts between 75k-100k and 50% for amounts over 100k. It must be an IF statement I assume. Any HELP greatly appreciated!!

Thanks to anyone who is able to help in advance!

Best,
Mark

[NeedForExcel]

Try this

=INDEX({0;0.3;0.4;0.5},MATCH(A1,{0;50000;75000;100000}))*A1

Assuming the Sales figures is in Cell A1

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.

[ercsearch]

Thanks both! Much appreciated!