IF not equal to in Excel

IF not equal to in ExcelAlthough 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 equal to 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 equal e.g. IF, SUMIFS, SUMPRODUCT etc.

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.