You and your friends decided to go to Goa after you finish your finals, However, your demanding parents set a couple of conditions to join your friends (See MS-EXCEL spreadsheet below)


Imagine your parents would care about exams (only Midterm score and Final exam score conditions are relevant). Choose one option/formula that you can use for cell D2 to answer the question: will you be able to join your friends with the results given?

Correct option is B

The correct option for the formula to use in cell D2 to determine whether you will be able to join your friends based on the given results is:
= IF (AND (C3 >= B3, C4 >= B4), "Yes", "No")
The formula checks two conditions using the AND function. The conditions are:
• Whether the actual midterm score (C3) is greater than or equal to the minimal midterm score (B3).
• Whether the actual final exam score (C4) is greater than or equal to the minimal final exam score (B4).
If both conditions are met, meaning the actual scores meet or exceed the required minimal scores, the formula will return "Yes", indicating that you will be able to join your friends.
If either of the conditions is not met, the formula will return "No", indicating that you will not be able to join your friends.
Therefore, the correct formula to use in cell D2 is: = IF (AND (C3 >= B3, C4 >= B4), "Yes", "No")
Information booster:
• Option 1 is incorrect because it uses the IF function twice. This is unnecessary, as the AND function can be used to combine two conditions into one.
• Option 3 is incorrect because it uses the colon (:) operator. This operator is used to reference a range of cells, but it is not necessary in this case.
• Option 4 is incorrect because it uses the OR function. The OR function would return "Yes" if either of the conditions were met, but in this case we need to check if both conditions are met.