Question is incomplete (See complete question below)
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
Explanation:
Here, the name of the cell is N2.
In order to write the required query, we need to first get a table name.
For the purpose of this query, we'll assume the table name to be STAFF_TABLE.
Taking the above condition into consideration, the formula is as follows;
--- See attachment-----
The above formula test for the conditions listed out above and displays "ELIGIBLE" or "NOT ELIGIBLE", without the quotes depending on the outcome of the condition of SERVICE_YEAR > 1
