OR (logical OR function)

<< Click to Display Table of Contents >>

OR (logical OR function)

Syntax:

OR(Value1 [, Value2, Value3 ...])

Description:

Returns the logical value TRUE if at least one of the given arguments is TRUE, otherwise it returns FALSE.

You can use this function to verify that at least one of multiple conditions is fulfilled.

Example:

OR(TRUE, TRUE) returns TRUE

OR(TRUE, FALSE) returns TRUE

OR(FALSE, FALSE) returns FALSE

OR(A1=0, A1>10) returns TRUE, if A1 is either zero or greater than ten.

See also:

XOR, AND, NOT