". If the inequality sign is used in the description, use the intelligent ABC input method and press V1 to turn to the third "≠" on page 4."/> ". If the inequality sign is used in the description, use the intelligent ABC input method and press V1 to turn to the third "≠" on page 4.">

Home  >  Article  >  Topics  >  How to type "not equal" in excel?

How to type "not equal" in excel?

尚
Original
2020-03-02 10:46:2735095browse

How to type

How to enter inequality in excel:

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn