Question

Carla needs to list the role for each consultant. Those with four or more years of 26 15 experience take the Lead role. Otherwise, they take the Associate role. List this information as follows: OLCSUEGO GOCOWEGO a. In cell N5 on the Project Status worksheet, enter a formula that uses the IF function to test whether the number of years of experience (cell M5) is greater than or equal to 4. b. If the consultant has four or more years of experience, display "Lead" in cell N5. C. If the consultant has less than four years of experience, display "Associate" in cell N5.

Answer 1

Answer :

The output is attached below

Explanation:

The following formula needs to be entered into cell N5:

=IF($M5>=4,"Lead","Associate")