Question

In cell K2 enter a formula using the IF and OR functions, as well as structured references to determine if Alison Simoneau can be a supervisor

A. Tbe IF function should first determine if the staff member's Service Years is greater than 5 OR if the staff member's college graduate status is "Yes". Remember to use a structured reference to the Service Years and the College Graduate columns.
B. The function should return the text Yes if a staff member meets one or both of those criteria.
C. The function should return the text No if a staff member meets neither of those criteria. tsor and have conlelea Academic Technology training.

Answer 1

Enter the following formula in a cell K2:

=IF(OR([at[College Graduate]]="Yes",[at[Service Years]]>5),"Yes","No")

Please replace "at" in the formula with its symbol.

Step-by-step explanation:

The formula has an IF function which checks a condition.

There are two conditions here to be checked:

A) if the staff member's Service Years is greater than 5.

B) if the staff member's college graduate status is "Yes".

According to the given criteria this IF function should return Yes if a staff member meets one OR both of the above mentioned criteria. Otherwise the function should return No.

This means if any one of the criteria evaluates to true then the text Yes is returned. For example if staff member's Service Years is greater than 5, then function returns Yes. For instance if staff member is a college graduate which means that his college graduate status is "Yes", then the function returns Yes.

The function still returns if either of the two criteria is true. For instance if staff member's Service Years is less than 5 but staff member's college graduate status is "Yes" then the function returns Yes.

However if neither the staff member's Service Years is greater than 5 nor the staff member's college graduate status is "Yes" then the function returns No.

So we use OR function here which with IF function so that the IF function returns true if either of the two criteria is met, otherwise returns false. This takes the form:

IF(OR(Argument 1 is True, Argument 2 is True), YES if True, NO if False)

Also there is at symbol used in the formula. Square brackets are used for structured references. They make clear and easier to reference. Structure reference is used if we want to use a table name in a formula such that we used in this IF OR formula, instead of a normal cell reference. "at" is used to refer only the mentioned/current rows or cells in the table. If you do not use this at then all the columns will be selected. For example [at[Service Years]]>5 is a reference to the cell in the Service Years at the current row. But [[Service Year]] is a reference to the entire column. So only those cells are checked where the Service Year is greater than 5.

Please replace the at word in the formula with its symbol.