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

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

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).

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.

Drag the cell downward to judge other cells.

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.

Drag the cell downward to judge other cells.

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!