UGC NET ICT Q1

Question

You and your friend 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 ask you to either meet the final exam score condition or both if the two remaining (homework and midterm) conditions. Which of the following formulas A-C can be used in the cell D2 to answer the question: will you be able to join your friends with the results given?

A. = IF (C4>=B4, "Yes", IF (AND(C2>=B2, C3>=B3), "Yes", "No"))
B. IF (AND (C2>=B2, C3>=B3), "Yes", IF (C4>=B4, ":Yes", "No"))
C. IF (OR (AND (C2>=B2, C3>=B3), C4>=B4), "Yes", "No")

Accepted Answer

and C only