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)
|
|
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 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?
1
= IF (C3 > = B3, IF (C4 > B4. "Yes", "No"), "No")
2
= IF (AND (C3 > = B3, C4 > = B4), "Yes", "No")
3
= IF (C3 : C4 > = B3: B4, "Yes", "No")
4
= IF(OR (C3 > = B3, C4 > = B4), "Yes", "No")