AND Function in Google Sheets

Evaluate multiple logical expressions in Google Sheets using the AND function.

AND Function

The AND function in Google Sheets returns TRUE if all the provided logical expressions are TRUE; otherwise, it returns FALSE.

Syntax

AND(logical_expression1, [logical_expression2, ...])

Examples

  1. Basic AND Logic

Check if both 5 > 3 and 10 < 15 are TRUE:

=AND(5 > 3, 10 < 15)

This will output TRUE.

  1. Multiple Conditions

Check if A1 is greater than 5 and B1 is less than 20:

=AND(A1 > 5, B1 < 20)

This will output TRUE if both conditions are met.

Notes

  • The function can handle multiple logical expressions.
  • The AND function is often used within IF statements to apply conditional logic.
  • OR: Returns TRUE if any of the provided logical expressions are TRUE.
  • IF: Returns a value based on a condition.