How to use OR function in excel?
Table of Contents
Use the OR function, one of the logical functions, to determine if any conditions in a test are TRUE.
Condition-1 If all arguments are TRUE then we will get TRUE in the result.
Condition-2 If one argument is FALSE then we will get TRUE in the result.
Condition-3 If all arguments are FALSE then we will get FALSE in the result.
Conclusion
If all arguments are FALSE then only we will get FLASE in the result otherwise we will get always TRUE in the result.
Syntax
OR(logical1, [logical2], …)
Examples
Here are some general examples of using OR by itself, and in conjunction with IF
Let’s check all three conditions mentioned above
Conditions
Condition-1
=OR(A2>1, A2<100) Displays TRUE if A2 is greater than 1 OR less than 100, otherwise it displays FALSE.
Now we can take some examples with IF condition
Condition 2
=IF(OR(A2>1,A2<100),A3,”The value is out of range”)
Displays the value in cell A3 if it is greater than 1 OR less than 100, otherwise, it displays the message “The value is out of range”.otherwise it displays FALSE.
Condition 3
=IF(OR(A2<0,A2>50),A2,”The value is out of range”)
Displays the value in cell A2 if it’s less than 0 OR greater than 50, otherwise, it displays a message.