Payroll

The bonus on top of base pay depends on years of service, according to the scale in I2:J5. The performance bonus is 15% of base pay if the employee met 100% of the target or more.

Calculate the monthly pay:

1. in E2:E9, the seniority bonus percentage from the scale;
2. in F2:F9, the performance bonus in dollars;
3. in G2:G9, the total: base pay with the seniority bonus plus the performance bonus.