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