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