Your parents set conditions for you to join your friends. In the spreadsheet, column B has minimal required results and column C has actual results. Only the midterm score in row 3 and the final exam score in row 4 are relevant, and both actual results must meet or exceed the minimum. Which formula for cell D2 answers whether you can join your friends?
A=IF(C3>=B3, IF(C4>B4, "Yes", "No"), "No")
B=IF(AND(C3>=B3, C4>=B4), "Yes", "No") ✓ Correct
C=IF(C3:C4>=B3:B4, "Yes", "No")
D=IF(OR(C3>=B3, C4>=B4), "Yes", "No")
Correct answer: (B) =IF(AND(C3>=B3, C4>=B4), "Yes", "No")
Explanation
The AND function checks that both the midterm and the final actual scores meet or exceed their minimums before returning Yes.
Using AND with two greater-than-or-equal tests captures the rule that both conditions must hold.
The nested IF choice tests the final with strictly greater than, which wrongly rejects an exact match.
Testing a whole range against another range in one IF does not give a single Yes or No answer.
An OR-based choice would say Yes when only one condition is met, breaking the both-required rule.
AND returns true only when every enclosed test is true, which fits a both-must-pass condition.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Practise on Mcqkart →🎓 Book an expert →