﻿ OR | Spread Formula Reference
In This Topic
OR
In This Topic

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.