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”.

 

Back to the list of logical functions