Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.
OR(A2 = "foo", A3 = "bar")
OR(logical_expression1, [logical_expression2, ...])
logical_expression1- An expression or reference to a cell containing an expression that represents some logical value, i.e.
FALSE, or an expression that can be coerced to a logical value.
logical_expression2, ...- [ OPTIONAL ] - Additional expressions or references to cells containing expressions representing some logical values, i.e.
FALSE, or expressions that can be coerced to logical values.
- The number 0 is logically false; all other numbers (including negative numbers) are logically true.
NOT: Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
AND: Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.
TRUE if at least one argument is
TRUE, accepts both
logical_value and range parameter.
Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.