Question

6. According to camp policy, staff members need to be at least 23 years old to transport students. Dean now wants to determine how many members of his staff will be available to drive. In cell J2, enter a formula using the IF function and a structured reference to determine if Adam Moriarty can be a Transportation team member. a. The IF function should first determine if the staff member’s age is greater than or equal to 23. Use a structured reference to the Age column. b. The function should return the text Yes if the staff member’s age is greater than or equal to 23. c. The function should return the text No if the staff member’s age is not greater than or equal to 23.

Answer 1

Answer:

This seems to be related to MS Excel, here we will discuss the related formula:

=IF(VLOOKUP("Adam Moriarty",$B$3:$C$5,2)>23,"Yes","No")

the name can also be written in adjacent to J2 cell i.e. I2 and its reference to be used in vlookup primary key as follows:

=IF(VLOOKUP(I2,$B$3:$C$5,2)>23,"Yes","No")

Explanation:

We have used simple IF function combined with VLOOKUP function to reference this formula to the table of names and ages of the members (here the table is $B$3:$C$5 and ages are mentioned in 2nd column of the table)

please find attached screenshot for clarification