Select the bonus rate value based on the Job Title and the appropriate VLOOKUP table located at the top of the worksheet. Use this bonus rate to calculate the bonus by multiplying the bonus rate by the Salary.

Assignment

If the third character in the employee ID is 0, or 2, or 4 or 6 or 8, insert the employee’s Annual Units Sold, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell V10 use the appropriate function to calculate the total Annual Units Sold that show up in the results.

Question 2

In cell W15:

If the employee’s Department is 1211 or 1202 or 1255, and the Rating is 1 or 2 or 4, and the Job Title is Sales Rep, multiply the Annual Units Sold by the price in cell N2, otherwise enter a 0 in the cell . Copy the function down to the other cells in the column.

In W10 use the appropriate function to calculate the total for all the employees.

Question 3

Select the bonus rate value based on the Job Title and the appropriate VLOOKUP table located at the top of the worksheet. Use this bonus rate to calculate the bonus by multiplying the bonus rate by the Salary. Copy the formula down to the rest of the cells in the column.

In Z10 use the appropriate function to calculate the lowest bonus for all employees.

Select the bonus rate value based on the Job Title and the appropriate VLOOKUP table located at the top of the worksheet. Use this bonus rate to calculate the bonus by multiplying the bonus rate by the Salary.
Scroll to top