1) Go to cell L9 and insert an IF function with a nested AND function to display Raise salary to $90K for all managers who earn a salary less than $90,000 and No raise for anyone who does not fit the criteria.

2) Use the fill handle to copy the function down, populating the rest of the Raise Status column. Select Fill Without Formatting to preserve the existing formatting.

3) Insert an IFS function in cell K9 to compare the hire date in cell D9 to see if it is after 7/1/2020 in cell H2. If true, multiply the salary in cell E9 by the 1% bonus rate in cell I2. In the Logical_test2 box, compare the hire date to see if it is after 7/1/2015 in cell H3. If true, multiply the salary by the 2% bonus rate in cell I3. In the Logical_test3 box, compare the hire date to see if it is after date 7/1/2005 in cell H4. If true, multiply the salary by the 3% bonus rate in cell I4. Type TRUE in the Logial_test4 box and 0 in the Value_if_true4 box. Use the mixed references to the references in column H and I.

4) Copy the function in cell K9 and paste the function in the range K10:K33 using the Paste Formulas option, and then press ESC.