Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

OR

Check if one of the multiple criteria match in Excel
Returns TRUE if any argument is TRUE

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.

Return Value

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:

Check if one of the multiple criteria match in Excel

SWITCH

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

Read More »
Returns TRUE when only one condition is true in Excel

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.

Read More »
Returns TRUE if all its arguments are correct in Excel

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.

Read More »