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. =NOT(OR(B2>=70, C2>=80))
b. =AND(B2>=70, C2>=80)
c. =IF(B2>=70, C2>=80)
d. =OR(B2>=70, C2>=80)
ANSWER: Option A is correct since, it turns to False if either B2 and/or C2 are false. The other options turn True when both are false.