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.

Illustration of OR function

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.
Also See:   Highlight values not between X and Y in Excel

 

Leave a Reply

Your email address will not be published. Required fields are marked *