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.