Question

8. To be a Bunk Leader, a staff member must have over 4 service years and have completed leadership training. In cell L2, enter a formula using the IF and AND functions, as well as structured references to determine if Adam Moriarty can be a bunk leader. a. The logical test in the IF function should determine if the staff member’s Service Years is greater than 4 AND the staff member’s Leadership Training status is “Yes”. Remember to use a structured reference to the Service Years and the Leadership Training columns. b. The function should return the text Yes if a staff member meets both of those criteria. c. The function should return the text No if a staff member meets none or only one of those criteria. I have pulled this, followed the instructions in question from Chegg putting in excel for my project. i am still doing this wrong. Can you help?

Answer 1

Following formula should be used in L2

=IF(AND(CBFStaff[[#Headers],[Years since First Aid Certification]]>4,CBFStaff[[#Headers],[Group Leader ]]="Yes"),'Yes","No")

In this formula, nested function AND checks whether the staff member meets both the criteria. If it meets botht eh criteria, then it will return text "Yes"

If it meets only one or none of the criteria, then it will return text "No"

This formula is applicable on the data formatted as Excel Table named CBFStaff.

Header "Years since First Aid Certification" shows the staff member's Service years.

And the header "Group Leader" shows the group leader status as either "Yes" or "No"