Question: 1 . To be eligible for the leadership training program offered by the office, a student must have at least 2 years of post -
To be eligible for the leadership training program offered by the office, a student must have at least years of postsecondary education or have gone through the organization finance training.
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.
Fill the formula into the range K:K if necessary
Help please. the formula I have entered is giving a good formula somewhat but not displaying the answers I am looking for
IFORStudentRepresentatives#HeadersPostSecondary YearsStudentRepresentatives#HeadersFinance Certified"Yes""yes","No
This is the formula that was entered. The formula has to be structured.
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
