How to tell excel not equal to

If you want Excel to check if a cell in Excel is NOT equal to something, you can do it in one of two ways.

Use <> to tell Excel not equal to

The first thing you can do is use a less than and bigger than symbol and combine them to create a not equal to. Unfortunately Excel does not allow ≠ (not equal to sign) but by using <> in a formula you are telling Excel the same thing.

As an example you could build an IF that says


which reads

“if cell A1 is not equal to 0, then display the word Number otherwise the word Zero”.

Use the NOT function

Another way to achieve the same thing is to use the NOT function.

In this case you can set up a logical test (e.g. A1=0) and tell Excel to do the exact opposite by using the NOT function i.e. NOT(A1=0).

In the IF example above we would therefore enter


For more knowledge at this level, have a look at our online Intermediate Excel course.