How can I use the AND function in Google Sheets?

The AND function returns true if all of 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.

[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdC1rNUYxeDYxQjhqX2xFWEI4X3JkcVE&single=true&gid=0&output=html&widget=true” width=”500″]