Documentation/Calc Functions/OR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

OR

Category:

Logical

Summary:

Returns TRUE if at least one argument is TRUE. This function returns the value FALSE, if all the arguments have the logical value FALSE.

Syntax:

OR(LogicalValue1; LogicalValue2 ...LogicalValue30)

Returns:

Arguments:

The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values.

LogicalValue1; LogicalValue2 ...LogicalValue30 are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range.

Additional details:

Examples:

The logical values of entries 12<11; 13>22, and 45=45 are to be checked.

=OR(12<11;13>22;45=45) returns TRUE.

=OR(FALSE;TRUE) returns TRUE.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: