## OR Function

Written by kazamraza
no comments

Classified in : Excel Formulas, Logical Functions

the OR function, one of the logical functions, to determine if any conditions in a test are TRUE.

## Syntax

```
OR(logical1, logical2, logical3 ......)
```

The OR function returns True if any one logical test is true.

Normally the OR function is not used in isolation. it is used along with IF function.

◢ | A | B | C | D | E |
---|---|---|---|---|---|

1 | Data |
Formula |
Description (Result) |
||

2 | 50 | =OR(A2>1,A2<100) | Displays TRUE if A2 is greater than 1 OR less than 100, otherwise it displays FALSE. | ||

3 | 100 | =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". | ||

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