The inequality sign is known from school as ≠, i.e. as a crossed-out minus. It looks different in Excel. Learn more..
In Microsoft Excel you can also use an inequality sign in addition to the equal sign "=". This is represented with "<>", that is, a less than sign and a greater than sign. The inequality sign is - as the name suggests - used to express an inequality. It can also be used to create a condition.
With the not equal sign you can query certain conditions in Excel. Just enter " =UND([Zellbezug]<>[Zahlenwert]) " (without the quotation marks) in any cell . Under cell reference you can enter any cell, such as B1 . It is important that you do not refer to the cell in which you entered this formula. Otherwise an error message will appear. Enter any number under Numerical value , for example 1 . If you want to add another condition, just use a semicolon . So a finished formula in cell A1 might look something like this:
=UND([Zellbezug]<>[Zahlenwert])
The formula used here is " =UND(A2<>1;A2<>0;B1<>0) ". It is therefore checked whether no 1 or no 0 is entered in cell A2 , and at the same time whether no 0 is entered in cell B1 . Since all three conditions are met, " TRUE " is output in cell A1 .
=UND(A2<>1;A2<>0;B1<>0)