The scores of a student in two subjects are inserted in cells B2 and C2. The passing score for each subject is 60. Which of the following formulas returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE?
A) =IF(B2=60, C2=60)
B) =OR(B2=60, C2=60)
C) =AND(B2=60, C2=60)
D) =NOT(OR(B2=60, C2=60))

Question

The scores of a student in two subjects are inserted in cells B2 and C2. The passing score for each subject is 60. Which of the following formulas returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE?
A) =IF(B2>=60, C2>=60)
B) =OR(B2>=60, C2>=60)
C) =AND(B2>=60, C2>=60)
D) =NOT(OR(B2>=60, C2>=60))

Quizplus · Accepted Answer

The OR function returns TRUE if at least one of the arguments is TRUE. So, in this case, if either B2 or C2 is greater than or equal to 60, the formula will return TRUE. If both scores are less than 60, the formula will return FALSE.

The Scores of a Student in Two Subjects Are Inserted