Home  >  Article  >  Topics  >  How to write multi-condition judgment of IF function in EXCEL

How to write multi-condition judgment of IF function in EXCEL

angryTom
angryTomOriginal
2020-02-14 17:44:0059052browse

In the application of table functions, we often use the "IF" function. Often when we use "IF" to interpret multiple conditions, we use multi-level nesting. However, we need multiple conditions, and it is difficult to return a true value only when one of the conditions is met, so we can use "AND" and "OR".

How to write multi-condition judgment of IF function in EXCEL

How to write multi-condition judgment of IF function in EXCEL

The definition of "AND":

Determine whether multiple conditions are true. The conditions are specified with "Logical" (logical expression). If all conditions are true, the return value is TRUE (true); if any condition is false, the return value is FALSE (false). That is, if any certain condition is not met, it is not met. Parameters are separated by commas, and up to 30 parameters can be specified.

Definition of "OR":

To determine whether any one of multiple conditions is true, the condition is specified with "Logical" (logical expression). If any condition is true, the return value is TRUE (true); if all conditions are false, the return value is FALSE (false). That is, it is satisfied if any certain condition is met.

Key points: Used nested with the IF function, it can be processed separately according to the judgment results of the AND function and according to the conditions. Check whether all conditions are true (AND means that all conditions are met, OR means any one condition satisfy).

How to write multi-condition judgment of IF function in EXCEL

Enter "=IF(OR(B10>=80,C10>=80),"Excellent","Poor")" in the cell. Indicates that when one of them is not satisfied, a false value "difference" is returned.

How to write multi-condition judgment of IF function in EXCEL

Drag the cell downward to judge other cells.

How to write multi-condition judgment of IF function in EXCEL

Enter "=IF(OR(B2>=80,C2>=80),"Excellent","Poor")" in the cell. Indicates that when one of them is satisfied, the true value "excellent" is returned.

How to write multi-condition judgment of IF function in EXCEL

Drag the cell downward to judge other cells.

How to write multi-condition judgment of IF function in EXCEL

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to write multi-condition judgment of IF function 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