The AND function returns true if all the provided arguments are logically true and false if any of the provided arguments are logically false.
Sample usage
AND(A2 = 'foo', A3 = 'bar')
AND(TRUE,FALSE,TRUE)
AND(A1:A10,B1:B10)
AND(0,1,2,3)
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. TRUE or 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. TRUE or FALSE, 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.