Skip to content
Google Sheets

AND function in Google Sheets

Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.

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

AND syntax and parameters

Two arguments, one required.

  • logical_expression1booleanRequired

    An expression or reference to a cell containing an expression that represents some logical value, i.e. TRUE or FALSE, or an expression that can be coerced to a logical value.

  • logical_expression2booleanRepeating

    [ OPTIONAL ] - Additional expressions or references to cells containing expressions representing some logical values, i.e. TRUE or FALSE, or expressions that can be coerced to logical values.

AND examples

Formulas you'll actually reuse.

  1. Is this a big West-region deal? Every condition must hold:

    =AND(D2 > 1000, A2 = "West")

    ResultTRUE

  2. A status that needs a ship date AND that date to have passed:

    =IF(AND(E2 <> "", E2 <= TODAY()), "Shipped", "Pending")

    Result"Shipped"

AND in Excel

Same name — your formula ports as-is.

Try AND in the playground

Edit the example — nothing to install.

Preloaded with the AND formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.