How to use the or function in Excel: 1. The or function is used to test a set of data. As long as one condition is met, the result will return true. The syntax format is [=OR(logical1,logical2,...) 】; 2. The or function is generally used in combination with logical functions such as if.
How to use the or function in Excel:
1. The or function is used to test a set of data. As long as one condition is met, the result will be Return true.
2. The syntax format of the or function
=OR(logical1,logical2,...)
where Logical1 and logical2 are the judgment conditions
3. Or function example
As shown in the figure, the or function is generally used in combination with logical functions such as if.
This is used to determine whether admission will be granted based on the evaluation results.
=IF(or(D2>85,E2>85,F2>85),"录取","不予录取")
Meaning of the formula: If any of the interview scores, written test scores, and comprehensive quality scores is greater than 85, admission will be granted, otherwise admission will be denied.
#4. As shown in the figure, the entire column of assessment results can be quickly calculated by filling in the formula through the drop-down menu. The effect is as shown in the figure.
#5. As shown in the figure, the or function can also be combined with the if function to quickly enter product categories.
=IF(OR(B2="打印机",B2="饮水机",B2="传真机"),"办公设备","电脑配件")
The formula states that as long as B2 is one of printers, water dispensers, and fax machines, it will return office equipment, otherwise it will return computer accessories.
Recommended tutorial: "excel basic tutorial"
The above is the detailed content of How to use the or function in Excel?. For more information, please follow other related articles on the PHP Chinese website!