How to determine whether the contents of two cells are consistent in Excel

We can use the IF() function to make judgments. The judgment method is as follows:

For example, we enter the formula [=IF(C2=E2,"Same as ","Not the same")】

You can also use numbers to judge, as follows:

At this time, if the content is the same, 0 will be displayed, if the content is different Display 1, both methods are the same.

Recommended tutorial: excel tutorial

The above is the detailed content of How to determine whether the contents of two cells are consistent in Excel. For more information, please follow other related articles on the PHP Chinese website!