OR function: Description, Usage, Syntax, Examples and Explanation

What is OR function in Excel?

OR function is one of the Logical functions in Microsoft Excel that determines if any conditions in a test are TRUE.

Example

Here are some general examples of using OR by itself, and in conjunction with IF.

Formula	Description
=OR(A2>1,A2<100)	Displays TRUE if A2 is greater than 1 OR less than 100, otherwise it displays FALSE.
=IF(OR(A2>1,A2<100),A3,”The value is out of range”)	Displays the value in cell A3 if it is greater than 1 OR less than 100, otherwise it displays the message “The value is out of range”.
=IF(OR(A2<0,A2>50),A2,”The value is out of range”)	Displays the value in cell A2 if it’s less than 0 OR greater than 50, otherwise it displays a message.