Question

Luke now wants to determine how many members of his staff will be eligible to be subject leaders. In cell J2, enter a formula using the IF function and a structured reference to determine if Allison Simoneau can be a subject leader. a. The IF function should first determine if the staff member is a college graduate. Use a structured reference to the College Graduate column. b. The function should return the text Yes if the staff member’s college graduate status is equal to Yes. c. The function should return the text No if the staff member is not a college graduate.

Answer 1

In J2 write the following function

=IF([College Graduate]="Yes","Yes","No")

Step-by-step explanation:

I assume that the table has already been created.

So, the explanation of the function is as follows:

= --> This begins an Excel formula

IF ---> The indicates that the formula uses the IF function

[College Graduate]="Yes" --> This condition checks if the College Graduate column is Yes

"Yes" --> If the condition is true, the content of J2 is Yes

"No" --> If the condition is false, the content of J2 is No