Question

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

asked Oct 15, 2021 27.4k views

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 as follows to determine if Kay Colbert can join the leadership training program: a. The IF function should determine if the student's Post-Secondary Years is greater than or equal to 2 OR if 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 K3:K31, if necessary.