A student's scores in two subjects are inserted in cells B2 and C2.The passing score for each subject is 60.Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?
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

A student's scores in two subjects are inserted in cells B2 and C2.The passing score for each subject is 60.Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?
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 Answer of A student's scores in two subjects are inserted in cells B2 and C2.The passing score for each subject is 60.Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?
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))

A Student's Scores in Two Subjects Are Inserted in Cells