Spread 8.0 Documentation
OR
Support Options
Formula Reference > Built-In Functions > OR

Glossary Item Box

OR


Name

Or

Description

Returns 1 (True) if any argument is True; returns 0 (False) if all arguments are False.

Syntax

OR(value1, value2, ...)

Remarks

Accepts up to 30 arguments. Provide numeric or logical values for the arguments.

See also AND, FALSE, IF, NOT, and TRUE.

Data Type

Accepts numeric (boolean) data for all arguments. Returns numeric (boolean) data. For more information, see Data Type for Each Cell Type.

Example

OR(1+1=1,2+2=5) = 0 (False)
OR(TRUE()) = 1 (True)

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.