The score of a student in two subjects are inserted in the B2 and C2 cells and the passing score for each subject is 60.Which of these functions will you insert in the D2 cell so that it 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 score of a student in two subjects are inserted in the B2 and C2 cells and the passing score for each subject is 60.Which of these functions will you insert in the D2 cell so that it 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 conditions is TRUE. So, by using the OR function with the conditions B2>=60 and C2>=60, it will return TRUE if at least one score is greater than or equal to 60, or else it will return FALSE.

The Score of a Student in Two Subjects Are Inserted