Question

In cell N2, enter a formula using the IF function and a structured reference to determine if Alison Simoneau is eligible for tuition remission.

a. The IF function should first determine if the staff member's Service Years 11 is greater than 1. Remember to use a structured reference to the Service Years column.
b. The function should return the text Eligible if the staff member's Service Years is greater than 1.
c. The function should return the text Not Eligible if the staff member's Service Years is not greater than 1.

Answer 1

In cell N2, enter a formula using the IF function and a structured reference to determine if Alison Simoneau is eligible for tuition remission.

=IF([Service Years]>

a. The IF function should first determine if the staff member’s Service Years is greater than 1. A structured reference to the Service Years column:

=IF([Service Years]>1,

b. The function should return the text Eligible if the staff member’s Service Years is greater than 1.

=IF([Service Years]>1,"Eligible"

c. The function should return the text Not Eligible if the staff member’s Service Years is not greater than 1.

=IF([Service Years]>1,"Eligible","Not Eligible")