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)

	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: