IF not equal to in Excel

IF not equal to in Excel

Although it is more common to specify in Excel when something is equal to something else e.g. B1=”Sale”, occasionally it is better (and more efficient) to do the opposite i.e. if not equal to xyz then do something.

‘Not equal to’ in Excel is expressed as <> . So in the example above we could say B1<>”Sales”.

This same logic works with numbers i.e. if not the same as zero, it would be shown as B1<>0 (note that for numbers we don’t use “inverted commas”).

The ‘Not Equal to’ symbol can be used in any function that can use an logical tests e.g. IF, SUMIFS, SUMPRODUCT etc.

YouTube IF not equal to

Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.