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")
<em>Analysis</em>
=: 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
