Home/Formulas/Logic/AND
Logiceasy

AND()

Returns TRUE if all of the provided arguments are logically true.

Syntax
fx
=AND(logical_expression1, [logical_expression2, ...])
Arguments
ArgumentDescription
logical_expression1An expression or reference that represents a logical value.
[logical_expression2, ...]Additional expressions or references. All must evaluate true for AND to return TRUE.
Try it
F2
→
TRUE
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Returns #VALUE! if any argument can't be coerced to a boolean. Empty cells coerce to FALSE.
  • Short-circuits in evaluation order is NOT guaranteed: every argument is evaluated, so don't depend on AND to avoid an expensive call.
  • For row-by-row boolean math inside ARRAYFORMULA or FILTER, use * (multiplication) instead of AND: AND collapses to a single value.
Related formulas
OR()
Returns TRUE if any of the provided arguments are logically true.
NOT()
Returns the opposite of a logical value: NOT(TRUE) = FALSE.
IF()
Returns one value if a condition is TRUE, another if FALSE.
Used by
IF()
Returns one value if a condition is TRUE, another if FALSE.
OR()
Returns TRUE if any of the provided arguments are logically true.
NOT()
Returns the opposite of a logical value: NOT(TRUE) = FALSE.
More Logic formulas →Keyboard shortcuts for Sheets →