How to type 'not equal' in excel?

How to enter inequality in excel:

If you use the inequality sign in the formula, enter "<>".

For example, if the value of cell A1 is not equal to 10, then the value of cell B1 is equal to 20, otherwise it is equal to 0. Enter in B1:

=IF(A1<>10,20,0)

If in the description Use the inequality sign in, use the smart ABC input method, press V1 to turn to the third page of 4 pages, "≠".

Recommended: "excel tutorial"

The above is the detailed content of How to type 'not equal' in excel?. For more information, please follow other related articles on the PHP Chinese website!