<< Click to Display Table of Contents >> OR (logical OR function)

Syntax:

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

Description:

This 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