se the appropriate nested functions: If the employee's Age is 63 or 64 or 65 or 66 , and the Gender is Male, and the Rating is 1 or 3 or 5, multiply the Annual Units Sold by the price in cell N2, otherwise enter a 0 in the cell. (Use absolute cell referencing where necessary). 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. Format comma style 0 decimal