Question: 1 . To be eligible for the leadership training program offered by the office, a student must have at least 2 years of post -

1. To be eligible for the leadership training program offered by the office, a student must have at least 2 years of post-secondary education or have gone through the organization finance training.
In cell K2 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 Post-Secondary Years column is greater than or equal to 2 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 K3:K31, if necessary
Help please. the formula I have entered is giving a good formula somewhat but not displaying the answers I am looking for
=IF(OR(StudentRepresentatives[[#Headers],[Post-Secondary Years]]>=2,StudentRepresentatives[[#Headers],[Finance Certified]]="Yes"),"yes","No")
This is the formula that was entered. The formula has to be structured.
1 . To be eligible for the leadership training

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!