Excel not equal sign

If you are using certain formula you may require the Excel not equal sign. In maths the symbol is an equal sign crossed out (≠) but this is not available in Excel.

So for example you are using an IF function and you want to check where a value is not equal to zero.

The Excel not equal sign is <>.

So the IF function for the example above would be

=IF(A1<>0, do one thing, do something else)

The other logical signs that may be useful:

  • >    greater than
  • >=  greater than or equal to
  • <   less than
  • <= less than or equal to
  • <> not equal to
  • = equal to

How to tell Excel ‘not equal to’