# OR

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



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](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionAND) \| [NOT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNOT) \| [Logical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functslogic)