Z
zephyr
I have a spreadsheet where I would like to pay a bonus based on hours worked.
A B C D E F G H
1 Limits Bonus Rate Hours Amount
2 > 0 ≤ 20 0% $20 17 $
3 > 20 ≤ 40 5% $20 23 $
4 > 40 10% $20 23 $
A2 to D4 is the limits to be applied. The limits can be changed.
E2 to E4 is the percentage bonus. The percentage can be changed.
F2 to F4 is the hourly rate.
G2 to G4 are the hours worked
Require the spreadsheet to calculate the amount based on applied limits.
Many thanks for any assistance that you can provide.
A B C D E F G H
1 Limits Bonus Rate Hours Amount
2 > 0 ≤ 20 0% $20 17 $
3 > 20 ≤ 40 5% $20 23 $
4 > 40 10% $20 23 $
A2 to D4 is the limits to be applied. The limits can be changed.
E2 to E4 is the percentage bonus. The percentage can be changed.
F2 to F4 is the hourly rate.
G2 to G4 are the hours worked
Require the spreadsheet to calculate the amount based on applied limits.
Many thanks for any assistance that you can provide.