Introduction to OR Function
Logical functions in Excel are predefined formulas that evaluate a given condition or set of conditions and return a Boolean value (TRUE or FALSE) based on whether the condition is met or not. They are used to test the truth or falsehood of a statement or a condition, and to make decisions based on the result. In this blogpost, we will discuss about OR Function in Microsoft Excel.
OR Function returns a Boolean value (TRUE or FALSE) after testing conditions you specify. In simple words, you can test multiple conditions with AND function and it returns TRUE if any of those (or all) conditions is TRUE and returns FALSE only if all those conditions are FALSE.
Download Sample File
Download SAMPLE FILE to work, practice and master the LOGICAL Functions in Excel.
Syntax of OR Function
OR(logical1, [logical2], …)
Arguments of OR Function
- logical1: Condition which you want to verify.
- [logical2]: Additional Conditions you want to verify.
Notes
- Values will be ignored if the reference cell or array contained an empty cell or text.
- The result of conditions should be in logical value (TRUE or FALSE).
- It will return an error if there is no logical value is returned.
Example of OR Function in MS Excel
In the below example, we have created a condition using IF function that if a student score 60 above marks in one of the both of the subjects the formula returns TRUE.
Now in the below example, we have used a number to get logical values in a formula. You can also perform the above condition in reverse order. You can use TRUE and FALSE instead of numbers. OR function treats these logical values as numbers.
Other Excel Logical Functions Tutorials
You can explore and master other Logical functions in Microsoft Excel. Here is a complete list of Logical functions available in Microsoft Excel.
