Excel OR() Function
The OR() function in excel tests the multiple sets of conditions and returns TRUE if any of the arguments are TRUE and FALSE if all the arguments supplied do not meet the criteria. You need to have a minimum of 2 conditions to check.
Syntax
OR (Logical 1, Logical 2, Logical 3, and soon..)
Parameter
Logical1 (required)- This parameter represents the first condition that needs to be checked.
Logical 2(optional)- This parameter represents the second condition which needs to be checked.
….(optional)- It represents the other conditions, that need to be checked.
Category
Logical
Return
The function returns TRUE value even if one of the conditions holds else returns a FALSE value. Basically, for a FALSE to appear, no conditions should hold.
Example 1
Objective: Test condition 1 and condition 2 to check whether the numbers are greater than 0 or not by using the OR function.
Condition 1 | Condition 2 | Result | Formula |
11 | 23 | TRUE | =OR(A20>0,B20>0) |
-1 | -2 | FALSE | =OR(A21>0,B21>0) |
-1 | 2 | TRUE | =OR(A22>0,B22>0) |
Example 2
Objective: Return TRUE if COL A is greater than COL B and COL B is less than COL C
Col A | Col B | Col C | Result | Formula |
167 | 502 | 61 | FALSE | =OR(B141>C141,C141<D141) |
903 | 895 | 967 | TRUE | =OR(B142>C142,C142<D142) |
Example 3
Objective: Using IF and OR function, check whether the student has passed or not. If the student has failed in 1 of the 2 subjects, then the student will be considered as Failed.
Student Name | Subject 1 | Subject 2 | Overall Result | Formula |
Reeta | PASS | PASS | PASS | =IF(OR(B28="FAIL",C28="FAIL"),"FAIL","PASS") |
Sweta | PASS | FAIL | FAIL | =IF(OR(B29="FAIL",C29="FAIL"),"FAIL","PASS") |
Baani | FAIL | PASS | FAIL | =IF(OR(B30="FAIL",C30="FAIL"),"FAIL","PASS") |
Aditya | PASS | PASS | PASS | =IF(OR(B31="FAIL",C31="FAIL"),"FAIL","PASS") |