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


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.

Return Value


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:

Evaluates each case and returns the associated variable that matches first.


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.

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


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 »
Returns TRUE when only one condition is true in Excel


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 »