OR

OR

Returns TRUE if any 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.

  • The arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values.
  • If an array or reference argument contains text, numbers, or empty cells, those values are ignored.
  • If the specified range contains no logical values, OR returns the #VALUE! error value.
  • You can use an OR array formula to see if a value occurs in an array. To enter an array formula, press CTRL+SHIFT+ENTER in Microsoft Excel 97 for Windows or COMMAND+ENTER in Microsoft Excel 97 for the Macintosh.

Examples

OR(TRUE) equals TRUE

OR(1+1=1,2+2=5) equals FALSE

If A1:A3 contains the values TRUE, FALSE, and TRUE, then:

OR(A1:A3) equals TRUE

Also see the example for EXACT