Ask Question
25 October, 21:16

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.

+2
Answers (1)
  1. 25 October, 21:29
    0
    =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
Know the Answer?
Not Sure About the Answer?
Find an answer to your 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, ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers