Asked by Daniel Alvarez on Jul 26, 2024

verifed

Verified

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) )

AND

A logical operator used in programming and mathematics that results in true only if all the operands are true.

  • Comprehend the implementation of logical functions (IF, AND, OR, NOT) for making determinations inside cells, contingent upon provided conditions.
verifed

Verified Answer

KY
Kaitlynn YoungJul 27, 2024
Final Answer :
C
Explanation :
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.