IF 'not equal to' in MS Excel. How to create a NOT EQUAL to logical expression in Excel
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
00:00 Not Equal to in Excel
00:08 Use 'not equal to' in an IF function in Excel
From https://www.auditexcel.co.za/blog/if-...
Images on website
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 [See website- angled brackets not allowed on YouTube] . So in the example above we could say B1[See website]”Sales”.
This same logic works with numbers i.e. if not equal to zero, it would be shown as B1[See Website]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.
