EQUAL TO Operator (=) - Excel
Overview
The Equal to operator (=) in Excel is a useful tool for comparing two values. This operator allows users to check if one value is equal to another.
Syntax:
=expression1 = expression2
expression1 and expression2 can be cell references, values, or more complex expressions.
Example: TRUE value
In this example, the Equal to operator is comparing two different values and returns a TRUE result. Cell C2 equals "apple” and cell D2 equals "apple” so the Equal to operator returns a TRUE value because they are identical.
Example:
=C2 = D2
Example: FALSE value
In this example, the Equal to operator is comparing two different values and returns a FALSE result. Cell C2 equals "apple” and cell D2 equals "banana” so the Equal to operator returns a FALSE value because they are not identical.
Example:
=C2 = D2