sing the appropriate nested functions to complete the following: If the sixth character in the employee ID is 0 or 1 or 2 or 3 or 4, 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 how many Annual Units Sold less than 20,000 show up in the results.