2. Student organizations sometimes require transportation for off-campus activities, and school policy requires students to be over 23 years old to serve as transport. Lael wants to determine how many of the active students will be eligible to transport other group members. In cell J2, enter a formula using the IF function as follows to determine if Kay Colbert can serve as authorized transport: a. The function should use a reference to the Age column to determine if the student's age is greater than 23, and should return the text Yes if true and No if false. b. Fill the formula into the range J3:J31, if necessary.

The required formula which determines the age of the student and displays a yes or no depending on whether the condition is true or not is =IF(C2>=23, 'Yes', 'No')

The IF function in excel, takes in three arguments or parameters ;

The first parameter, checks if the age of students is 23 years or greater.

The second parameter displays the string 'Yes' if the condition is met

The third parameter displays the string 'No' if the condition isn't.

To extend the formula to other range of cells in the sheet, drag the fill handle and it will use relative reference to apply the formula to corresponding cells on the Sheet.

Therefore, the appropriate excel function would be =IF(C2>=23, 'Yes', 'No')

Learn more : link

=IF(B2>=23,"Yes","No")

Explanation:

Given

Name = Kay Colbert

The Name column can't be used to determine the eligibility of a student to the transport.

What is needed is the corresponding age column of Kay's age.

Assume that the age column is B2 and the result column is C2 (See Attachment)

Enter the following in C2

=IF(B2>=23,"Yes","No")

This will return "Yes" without the quotes in cell C2 if B2 is greater than 23

Else, it'll return "No" without the quotes.

To drag the formula to other column, follow the instructions below

Select cell C2.

Rest your cursor in the lower-right corner so that it turns into a plus sign (+), like this:

Drag the fill handle downwards

lick on your profile and select log out on that device