Spread Formula Reference
OR
Formula Functions > Functions M to Q > OR

This function calculates logical OR. It returns TRUE if any of its arguments are true; otherwise, returns FALSE if all arguments are false.

Syntax

OR(bool1,bool2,...)

OR(array)

OR(array1,array2,...)

OR(expression)

OR(expression1,expression2,...)

Arguments

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.

Data Types

Accepts logical data (Boolean values of TRUE or FALSE) or numerical values (0 or 1). Returns logical data (Boolean values of TRUE or FALSE).

Examples

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

Version Available

This function is available in product version 1.0 or later.

See Also

AND | NOT | Logical Functions