Question: 7. In cell N3, enter a formula using the IF function and structured references as follows to determine which employment level Tiffany Adams is qualified

7. In cell N3, enter a formula using the IF function and structured references as follows to determine which employment level Tiffany Adams is qualified for:

a. The IF function should determine if the employee's Years of Experience is greater than or equal to 4, and return the value 2 if true or the value 1 if false.

b. Fill the formula into the range N4:N32, if necessary.

7. In cell N3, enter a formula using the IF

File Home Insert Draw Page Le Formul Data Review View Help Design Tell me N3 fx K L M N Eligibility Swim Team Yes Level Team Coach #NAME? No Yes Yes Yes Yes 10 2 5 8 8 8 8 8 5 5 5 5 5 5 5 5 o 0 - 0 3 2 1 0 - 11 12 13 14 15 16 17 18 19 20 21 22 23 No Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes No Ye: No Documentation CPR Course No Trained No Trained Trained Trained Trained No No Trained Trained No Trained No Trained Trained Trained Trained Trained No Trained No Trained Mi... 1 24 25 All Employees E

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!