PURPOSE

To compare more than 2 cells to check if they are equal.

RESULT

0 for false, 1 for true.

SYNTAX | EXAMPLE

=(A1=B1)*AND(B1=C1)

DESCRIPTION

The example above checks that the value in cell A1 is equal to the value in B1 AND to the value in C1.