In cell N2, enter a formula using a nested IF function to determine the number of bonus vacation weeks an employee will earn. Employees are awarded bonus vacation weeks based on their years of service(shown in column M ). Use structured references and the following parameters when creating this formula: a) If the employee's years of service field value is greater than 20, the formula should return the value 2 (indicating 2 bonus weeks of vacation). b). If the employee's years of service field value is greater than 15 the formula should return the value 1 (indicating 1 bonus week of vacation). c) If the employee's years of service field value is greater than 0, the formula should return the value 0 (indicating 0 bonus week of vacation).

M Age Years Service N Bonus Week o Max 401(k) Company Match 54 65 48 55 50 57 61 62 227 21.7 20.7 20.7 20.7 18.7 18.7 18.7 17.7 17.7 16.7 16.7 58