OpenOffice3.org Calc 3. Logical Functions
OR(logical value 1; logical value 2; ...) Function
Returns a logical value. This function
returns TRUE if at least one of the arguments of the function evaluates to TRUE.
This function only returns FALSE if all arguments given to the function is
evaluated as FALSE. This function can have minimum 1 and maximum 30 arguments.
Each argument can contain an expression that returns a logical value or a
reference to a cell containing the condition to evaluate. The logic functions
are useful if used along with other functions. Consider the following examples
to better understand the explanation.
=OR(A1>5;B1<6) Returns TRUE if the cell A1 contains a number greater than 5 or
if cell B1 contains a number less than 6. The function returns TRUE if at least
one argument is TRUE.
=OR(E9;F9) In this case, the function has two arguments. It evaluates the
contents of the E9 and F9 cells, if any of them evaluates to TRUE, the function
returns TRUE. Each cells contains a formula that returns a logical value.
=OR(TRUE();A1 = "blue") The function always returns the logical value TRUE
because the first argument is the TRUE() function. The second argument is TRUE
if cell A1 contains the word “blue”.