The value in cell B2 cell is 65.In cell C2, the value is 75.Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?
A) =IF(B2=70, C2=80)
B) =OR(B2=70, C2=80)
C) =AND(B2=70, C2=80)
D) =NOT(OR(B2=70, C2=80))

Question

The value in cell B2 cell is 65.In cell C2, the value is 75.Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?
A) =IF(B2>=70, C2>=80)
B) =OR(B2>=70, C2>=80)
C) =AND(B2>=70, C2>=80)
D) =NOT(OR(B2>=70, C2>=80))

Quizplus · Accepted Answer

The formula =AND(B2>=70, C2>=80) will only return TRUE if both conditions are met (B2 is greater than or equal to 70 and C2 is greater than or equal to 80). If either of the conditions is false, the formula will return FALSE. Therefore, this formula will return FALSE if any of the conditions are false, which is what is required by the question. The other formulas may not necessarily return FALSE depending on the values in the cells.

The Value in Cell B2 Cell Is 65