OR

  • Updated

Returns TRUE if at least one argument is TRUE. Returns FALSE if all of the arguments are FALSE.

Sample Usage

OR(TRUE,FALSE)
OR(C5,C6)
OR(A2>1,A2<100)

Syntax

OR(logical_expression1, [logical_expression2,..])

  • logical_expression1 - An expression or reference to a cell containing an expression that represents some logical value. Each expression must be either TRUE or FALSE.
  • logical_expression2,.. - [OPTIONAL] An expression or reference to a cell containing an expression that represents some logical value. Each expression must be either TRUE or FALSE.

Examples

OR(TRUE,FALSE) returns a value of TRUE.
OR(FALSE,FALSE) returns a value of FALSE.
OR(A2>1, A2<100) returns TRUE if A2 is greater than 1 or less than 100, otherwise it displays FALSE.

Notes

  • The number 0 is logically false; all other numbers (including negative numbers) are logically true.