Skip to content
Excel

AND function in Excel

Returns TRUE if all of its arguments are TRUE

=AND(logical1, [logical2], ...)

AND syntax and parameters

Two arguments, one required.

  • logical1booleanRequired

    Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.

  • logical2booleanRepeating

    Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.

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 Google Sheets

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 Excel gets this done.