OR

Returns the logical OR of all the given Boolean values

Syntax:

OR(list)

Returns the logical OR of the Boolean values in the list, which may be an array, a range of cells, or a comma-separated list of values.

If all parameters passed to the OR function are FALSE, the Boolean value FALSE is returned; otherwise TRUE is returned.

Unlike the corresponding logical operator ¦, all parameters of the OR function are always evaluated.

Example:

OR(A1, A2)

where the cell values are TRUE and FALSE will return the Boolean value TRUE.

Added in 2.00.