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.
Was this article helpful?
YesNo