Select the AND-Nest IF sheet. Enter a function into cell H7 that calculates the amount the bonus will be for each employee based on their hire date and pay. There are three possible levels of bonus based on the percentages in J2:J4 (Hint: you need to use a nested if to deal with three possible outcomes). If the employee was hired BEFORE (not including hired on) the date in I2 then their bonus is their current salary multiplied by the value in J2. If they were hired between the value in I2 and I3 (including the date in I3) then their bonus is their salary multiplied by the value in J3. Everyone else will receive a bonus of their salary multiplied by J4. Use the appropriate absolute references and copy the function through row 26.