A B C D E F G H 1 An employee's raise is a function of the Annual Evaluation Score that they received. 2 An employee will receive a raise according to the Evaluation/Raise Matrix below, but ONLY if 3 they received a score of 3.0 or higher. Use a VLOOKUP function inside an IF statement to 4 calculate the 2019 Salary for each employee. Format the 2018 and 2019 Salary figures 5 with dollar signs and zero decimals. 6 7 8 Annual 2018 Base Evaluation 2019 Base 6 Name Salary Score Salary 10 Doe, John 34500 11 Garza, Esperanza 42000 12 Hernandez, Joey 39600 13 O'Connor, Liz 55000 14 Smith, Sammy 48500 617300 6.2 1.3 7.6 3.9 8.8 23698 15 16 17 18 Evaluation/Raise Matrix: 19 20 21 23 24 25 26 22222222 Evaluation Score Raise 6246 COO 0.0 1.0% 2.0 2.0% 4.0 3.0% 6.0 4.0% 8.0 5.0% 10.0 6.0%