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