This article brings you relevant knowledge about excel, which mainly introduces the related issues of AND and OR functions, which are often used to judge multiple conditions. The two have different parameters. Depending on the conditions, there will be different results. Let’s take a look at them below. I hope it will be helpful to everyone.
Related learning recommendations: excel tutorial
AND function is used to judge multiple conditions.
The logical value TRUE is returned only when the results of all parameters return logical value TRUE. If the result of any parameter is FALSE or equal to 0, the AND function result is FALSE.
As shown in the figure below, when the security check results of all drive letters are true, it can be proved that the security check results of the entire system are true.
#Corresponds to the OR function. If the result of any parameter is TRUE, the result of the OR function is TRUE.
As shown in the figure below, when the virus check results of all drive letters are false, it can be proved that the virus check results of the entire system are false.
Commonly used examples:
As shown in the figure below, the packaging quality of column B must be less than or equal to 500 and greater than or equal to 495 before it is judged as Qualified, otherwise it is unqualified.
The formula is:
=IF(AND(B2>=495,B2
In this example, if both conditions are "TRUE" after comparison, the AND function returns TRUE, and the IF function returns the specified content "qualified", otherwise it returns "unqualified".
If the conditions are lowered and "qualified" is returned if one of the two conditions is met, the AND in the formula can be written as OR.
=IF(OR(B2>=495,B2
Related learning recommendations: excel tutorial
The above is the detailed content of AND and OR functions in Excel use parsing. For more information, please follow other related articles on the PHP Chinese website!