In cell U15: Use the appropriate nested functions: If the employee Last Name ends with A OR E OR S OR T AND begins with A OR D OR M, calculate the employee's lowest Units Sold for Qtr 1, Qtr 2, Qtr 3 and Qtr 4 (L15:015), otherwise the cell should be blank. Copy the function down to the other cells in the column. In U10 use the appropriate function to calculate the total units. Format comma style 0 decimal. Blank 1 Blank 1 Add your answer In cell U15: Use the appropriate nested functions: If the employee Last Name ends with A OR E OR S OR T AND begins with A OR D OR M, calculate the employee's lowest Units Sold for Qtr 1, Qtr 2, Qtr 3 and Qtr 4 (L15:015), otherwise the cell should be blank. Copy the function down to the other cells in the column. In U10 use the appropriate function to calculate the total units. Format comma style 0 decimal. Blank 1 Blank 1 Add your