Microsoft Excel Office 365
Learn How to Use Microsoft Excel OR Function
In this article, you will learn how to use the Microsoft Excel OR function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel OR function return value and syntax with the help of some examples.
Microsoft Excel OR Function
The Microsoft Excel OR function allows you to test multiple conditions. The OR function is the logical function, and with it, you can try the numerous conditions at the same time. Suppose you want to test either "A" or "B" you can use =OR(A1="A", A1="B"). So, it is a very simple function and can be used inside the IF function so that you can avoid extra nested IF's. You can always combine the OR function can also be combined with the AND function.
OR Function Return Value
The OR function returns TRUE if any one of the arguments evaluates TRUE and FALSE if both of them are FALSE.
OR Function Syntax
- logical1: This is the first condition or the logical value you want to evaluate.
- logical2: This is the second condition or logical value you want to consider (optional).
How to Use Microsoft Excel OR Function?
You can use the OR function to test up to 255 multiple conditions. Each logical condition must return either TRUE or FALSE, or it can be arrays or references containing the logical values. The OR function examine all the values, and return TRUE if any one of the value is TRUE, in the same way, if not any value evaluates to be TRUE, the OR function will return FALSE.
Check out the list of all other articles:
- Learn How to Get nth Match in Microsoft Excel
- Learn How to Find Missing Values in Microsoft Excel
- Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
- Learn How to Sort by Text Length in Microsoft Excel
- Learn How to Sort by Two Columns in Microsoft Excel
- Learn How to Sort by Random in Microsoft Excel
- Learn How to Sort by One Column in Microsoft Excel
- Learn How to Sort by Custom List in Microsoft Excel