🔀 Logical Function · beginner
AND Function in Google Sheets
Returns TRUE if ALL arguments are TRUE.
Syntax
AND(logical_expression1, [logical_expression2, ...])Returns: TRUE if every argument is TRUE.
Excel equivalent: AND (identical)
Parameters
| Name | Required | Description |
|---|---|---|
| logical_expression1, logical_expression2, ... | Required | Conditions to evaluate. |
Examples
Two conditions in IF
=IF(AND(A2 > 100, B2 = "Paid"), "VIP", "Standard")VIP only when both hold.
Many positive
=AND(A2 > 0, B2 > 0, C2 > 0, D2 > 0)TRUE only if all four positive.
CF custom formula
=AND($A2 > 100, $B2 = "Paid")Highlight rows.
When to use an alternative
- OR — Any-of-many.
- NOT — Invert.
- * operator — Array formulas.
Common errors and how to fix them
Breaks in arrays
Cause: Collapses to single TRUE/FALSE.
Fix: Use *: (A:A>0) * (B:B>0).
Related functions
OR
Returns TRUE if any argument is TRUE....
IF
Returns one value when a condition is true and a different value when false. The foundation of condi...
IFS
Evaluates multiple conditions in order and returns the value associated with the first TRUE conditio...
IFERROR
Returns a fallback value when a formula returns an error, otherwise returns the formula's result. Th...
SWITCH
Returns the value matching the first matching case. Lookup-style branching for equality matches....
Frequently Asked Questions
Short-circuit?
No — evaluates all. Use nested IF for short-circuit.
Range as argument?
Yes — AND(A1:A10) returns TRUE if every cell is TRUE.