Question: 1 . In cell K 2 enter a formula using the IF and OR functions and structured references as follows to determine if Kay Colbert
In cell K enter a formula using the IF and OR functions and structured references as follows to determine if Kay Colbert can join the leadership training program:
a The IF function should determine if the value in the student's PostSecondary Years column is greater than or equal to OR if the value in the student's finance certified status is "Yes", returning the text Yes if a student meets one or both of those criteria or the text No if a student meets neither of those criteria.
b Fill the formula into the range K:K if necessary.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
