Check if one of the multiple criteria match.
The Excel OR function is a logical operator that returns TRUE if only one of the conditions (logical) is TRUE.
For example, =OR(A1=10,A1=100) check if cell A1 contains either 10 or 100, if one of the criteria match with A1 value, formula return TRUE, otherwise FALSE.
=OR(logical1, [logical2], …)
logical1 -The first criteria to evaluate
logical2 [optional] – Additional criteria to test, up to a maximum of 255 criteria.
TRUE or FALSE
- The OR function evaluate multiple arguments and return TRUE even if one criterion match.
- OR function can be useful to perform the logical test along with other functions and complicated formula in Excel.
Example (Image above)
Suppose that user wish to test formula inside the IF function like here in cell D7 =IF(OR(75>B7,75<C7),”In Range”, “Out of “Range”) it return In Range as 30 is less than 75 and 300 is greater than 75.