Related Topics: | ||
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]
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.