What is the comparison operator used for not equal to in Excel?

You can use the Not function or the <> operator, which is the < and the > beside each other. To see if the values in A1 and A2 are not equal to each other, you can type:

=A1<>A2

or

=Not(A1=A2)

In each case they will either give you TRUE if they are not equal or FALSE if they are equal, in the cell that you enter the formula into.