| A | B | C | D |
| 1 | Category of condition | Minimal results needed | Actual results | Allowed (Yes/No)? |
| 2 | Hours spent on homework weekly | 2 | 3 | |
| 3 | Midterm score | 70 | 68 | |
| 4 | Final exam score | 75 | 77 | |
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")
Choose the correct answer from the options given below: