Excel not equal sign

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