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)A1B1 is equal to C2

Question

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)A1>B1 is equal to C2

Quizplus · Accepted Answer

The formula will return the value in C2 if the value in A1 is not equal to the value in B1. If A1 and B1 are equal, the formula will return the value in C1. The other two options in the answer choices do not affect the formula.

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