Theory:
To test if the values of 2 adjacent cells match exactly do the following:
=cell1=cell2
The results will be displayed as "True" if the pairs match or "False" if the pairs don't match.
Example:
You want to compare cell A2 to cell B2. Let's say both cells have the value of 108. The formula would be:
=A2=B2
The result would be "True".
To test if the values of 2 adjacent cells match exactly do the following:
=cell1=cell2
The results will be displayed as "True" if the pairs match or "False" if the pairs don't match.
Example:
You want to compare cell A2 to cell B2. Let's say both cells have the value of 108. The formula would be:
=A2=B2
The result would be "True".
0 comments:
Post a Comment