Experiential students who are at least 21 years old and have completed at least three years of post-secondary study may volunteer as mentors. In cell L2, insert the following formula, which makes use of the IF and AND functions, as well as structural references, to assess if Kay Colbert is eligible to serve as a mentor: It is expected that the IF function will determine if the student's age is more than or equal to 21 AND whether the student's post-secondary years are greater than or equal to 3, and that it will return the text. Yes, if a student fulfils both of those requirements, or if the text says so. If a student does not satisfy all of the requirements or just one of them, the answer is no. Can you tell me the formula for doing this in Excel?
Experiential students who are at least 21 years old and have completed at least three years of post-secondary study may volunteer as mentors. In cell L2, insert the following formula, which makes use of the IF and AND functions, as well as structural references, to assess if Kay Colbert is eligible to serve as a mentor:
It is expected that the IF function will determine if the student's age is more than or equal to 21 AND whether the student's post-secondary years are greater than or equal to 3, and that it will return the text. Yes, if a student fulfils both of those requirements, or if the text says so. If a student does not satisfy all of the requirements or just one of them, the answer is no.
Can you tell me the formula for doing this in Excel?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
