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
The Solution
First convert the above data into a table in excel from Insert tab, selecting the entire table and clicking on insert table
Then add the following formulas
Column K: IF(OR([@[Service Years]]>5,[@[College Graduate]]="Yes"),"Yes","No")
Column L: IF(AND([@Supervisor]="Yes",[@[Academic Technology Training]]="Yes"),"Yes","No")
The following result will be obtained
The following formula have been entered
