In the formula =IF(A1=B1,C1,C2),the result will be C2 if ____.
A) A is equal to B
B) A does not equal B
C) A1+B1 is equal to C1
D) none of the above

Question

Quizplus · Accepted Answer

The IF function checks if the value in cell A1 is equal to the value in cell B1. If they are not equal, the formula returns the value in cell C2. Therefore, option B is the correct answer, which means if A does not equal B, the result will be C2.

In the Formula =IF(A1=B1,C1,C2),the Result Will Be C2 If ____