OR:
Returns TRUE if any argument is TRUE
The OR function can be useful when combined with other functions like IF. The simple way to think about the OR function is that you pass one or more arguments (logical tests or conditions) to the function
and if any of the arguments evaluate to TRUE, then the OR function returns TRUE. If none of the conditions evaluate to TRUE, then the OR function returns FALSE.
So, it's a logical test that can compare up to 255 conditions.
OR takes
1 required argument and
254 optional arguments:
Syntax: OR(logical1,
[logical2], ...
)
The arguments for the OR function are:
Argument

Required?

Description

logical1 
Required 
The first condition that you want to test that can evaluate to either TRUE or FALSE. 
logical2, ... 
Optional 
Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions. 
The OR function checks to see if any of the tested conditions are true.