Syntax
AND(logical_expression1, [logical_expression2, ...])
logical_expression1- An expression or reference to a cell containing an expression that represents some logical value, i.e.TRUEorFALSE, 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.TRUEorFALSE, or expressions that can be coerced to logical values.
Notes
- The number 0 is logically false; all other numbers (including negative numbers) are logically true.
See Also
OR: The OR function returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.
NOT: Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
Examples
Returns TRUE if all arguments are TRUE, returns FALSE if any element is FALSE, accepts both logical_value and range parameter.