Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

OR

Description: Returns TRUE if any one argument is true. Returns FALSE if all arguments are false.

Syntax: OR(Logical1, Logical2, ...)

• Logical1, Logical2, ... are 1 to 30 conditions you want to test that can be either TRUE or FALSE.

Remarks:

• The arguments must either be the logical values TRUE or FALSE, or the arguments must be arrays or references that contain logical values.

• If an array or reference argument contains text or empty cells, those values are ignored.

• If the specified range contains no logical values, OR returns the #VALUE! error value.

Example:

• OR(TRUE) = TRUE [all arguments are TRUE]

• OR(1 + 1 = 1, 2 + 2 = 5) = FALSE [all arguments evaluate to FALSE]

• OR(TRUE, FALSE, TRUE) = TRUE [at least one argument is TRUE]