OR

Rational

Check if one of the multiple criteria match.

Description

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.

Syntax

=OR(logical1, [logical2], …)

Parameters

logical1 -The first criteria to evaluate
logical2 [optional] – Additional criteria to test, up to a maximum of 255 criteria.

TRUE or FALSE

Key Notes

• 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.

Keep Reading Similar Functions:

XOR

The XOR function returns TRUE when only one of the logic or condition is true. It returns TRUE if only one is right, not ‘at least one’ like OR function.

AND

The AND function is a logical operator that join two or more criteria i.e., if A2 is 75, =AND(A2>1,A2<50), return “FALSE” as none of the condition matches.

SWITCH

The Excel SWITCH function lookup value in a list of multiple labels and return the corresponding first match otherwise default clause or #N/A return.