This function calculates logical OR. It returns TRUE if any of its arguments are true; otherwise, returns FALSE if all arguments are false.
OR(bool1,bool2,...)
OR(array)
OR(array1,array2,...)
OR(expression)
OR(expression1,expression2,...)
Provide numeric (1 or 0) or logical values (TRUE or FALSE) for up to 255 arguments. You can also specify a single array instead of listing the values separately, or up to 255 arrays. Similarly, you can specify an expression or up to 255 expressions.
Accepts logical data (Boolean values of TRUE or FALSE) or numerical values (0 or 1). Returns logical data (Boolean values of TRUE or FALSE).
OR(B3,B6,B9)
OR(R1C2,R1C3,R1C4,R1C5)
OR(D2:D12)
OR(R12C1:R12C9)
OR(TRUE,FALSE,FALSE) gives the result TRUE
OR(TRUE()) gives the result TRUE
OR(FALSE(),FALSE()) gives the result FALSE
OR(1+1=1,2+2=5) gives the result FALSE
OR(5+3=8,5+4=12) gives the result TRUE
This function is available in product version 1.0 or later.
AND | NOT | Logical Functions