**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:

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

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

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