salary

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 […]

Scroll to top