OR function

Updated on Aug 22, 2025

1 minute(s) read

Description

Tests to see if at least one condition is met.

Syntax

logical1 OR logical2…

Return type

Boolean (TRUE or FALSE)

Examples

Case	Results	Return Type
`TRUE OR FALSE`	`TRUE`	`boolean`
`x > 2 OR y > 2`	`TRUE` if x or y are greater than 2, `FALSE` otherwise	`boolean`
`TRUE OR Blank`	`TRUE`	`boolean`
`Blank OR TRUE`	`TRUE`	`boolean`
`FALSE OR Blank`	`FALSE`	`boolean`
`Blank OR Blank`	`Blank`	`boolean`

Excel equivalent: OR(logical1, [logical2], ...)

See also: AND

Was this article helpful?