This article explains how to use the comparison operator I= in Excel. Instructions apply to Excel versions 2019, 2016, 2013, 2010, Excel Online, and Excel for Mac.

There are six comparison operators available that you can use in Excel.

These operators are used to test for conditions such as:

All comparison operators work on values, but some (such as <> and =) also work on strings (text) and dates.