Full 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 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:
See Attachment for answer
Explanation:
Given:
Cell: N2
Condition: to check if the staff member's Service Years is greater than 1
Before this question can be solved, a table name is needed.
The query to test the above condition will be executed on this table;
Assume table name is; Staffs;
In cell N2, write the following:
--- See attachment-----
The query checks if SERVICE YEAR is greater than 1. The result of this condition determines the next line of action.
1. If yes; it displays "ELIGIBLE" without the quotes in cell N2
2. Else, it displays "NOT ELIGIBLE" without the quotes in cell N2
