Question

Experienced students may serve as mentors if they are at least age 21 and have at least 3 years of post-secondary education. In cell L2, enter a formula using the IF and AND functions as follows to determine if Kay Colbert is eligible to serve as a mentor: The IF function should determine if the student's age is greater than or equal to 21 AND the student's post-secondary years are greater than or equal to 3, and should return the text Yes if a student meets both of those criteria or the text No if a student meets none or only one of those criteria. Fill the formula into the range L3:L31, if necessary.

Answer 1

Answer:

=IF(AND(B2>=21,C2>=3),"Yes","No")

Explanation:

Given

Age: Not less than 21

Post secondary education: Not less than 3 years

Required:

Enter a formula using the IF and AND functions as follows to determine if Kay Colbert is eligible to serve as a mentor

The excel file showing the records is not provided; So, in other to solve this question following assumption will be made

• Cell B2 represents age
• Cell C2 represents post secondary education

After giving you the formula using my illustration, all you need to do is to edit the cell names to suit your purpose;

Type the following in Cell L2

=IF(AND(B2>=21,C2>=3),"Yes","No")

Analysis

=: An excel formula must start with =

IF: This shows the function being used

AND: This shows that there are more than one condition in the IF function; all of which must be true

B2>=21,C2>=3: These are the two conditions in the question;

Note that B2 represents the student age and C2 represent the student post secondary education.

"YES": The IF function will return "Yes" without the quotes, if both conditions are true

"NO": Otherwise, the function will return "No" without the quotes

To fill the formula in L3 to L31, all you need to do drag the formula from L2 down to L31