Employees are assigned a Level based on their years of servi…

Questions

Emplоyees аre аssigned а Level based оn their years оf service.In cell L2, enter a nested IF function that evaluates the value in cell H2 and returns the employee’s level based on the following rules:If the employee’s years of service are 2 or fewer, return Entry.If the employee’s years of service are between 3 and 5 (inclusive), return Junior.If the employee’s years of service are greater than 5, return Senior.You may use the input cells in N3 and N4 as part of your formula, but do not create any additional input cells.Type or paste your formula below. Do not use table references.