AND Function

Used within another function to return true if all provided logical expressions are true.
Sample Usage
IF(AND(Status1 = "Complete", Status2 = "Complete", Status3 = "Complete"), "All Tasks Complete", "Tasks Incomplete")
Syntax
AND(
  • logical_expression1
  • [
    • logical_expression2
      • ​
    • ...
    ]
)
  • logical_expression1
    —
    Expression that evaluates to either true or false.
    • logical_expression2
      • ​
    • ...
    —[optional]
    Additional expressions that evaluate to true or false.
Related Functions
NOT
OR
IF
COUNTIF
COUNTIFS
SUMIF
SUMIFS
Related Articles
Frequently Asked Questions About Using Formulas
Was this article helpful?
YesNo