Logical

AND Function in Excel

Returns TRUE if all arguments are TRUE; returns FALSE if any argument is FALSE.

Syntax

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

Arguments

  • logical1 (required): First condition to evaluate
  • logical2 (optional): Additional conditions (up to 255)

Examples

  • =AND(A1>0, A1<100) - Check if value is between 0 and 100 - Result: TRUE or FALSE
  • =IF(AND(B1="Yes", C1>50), "Approved", "Pending") - Multiple criteria check - Result: Approved or Pending

Excel AND function documentation

  • AND is a Logical function that returns TRUE only when all arguments evaluate to TRUE.
  • Syntax: =AND(logical1, [logical2], …). Up to 255 arguments in modern Excel.
  • Common inside [IF](/functions/if/): =IF(AND(A2>0, B2="Open"), "Yes", "No").
  • Related: [OR](/functions/or/), [NOT](/functions/not/), [IFS](/functions/ifs/).

AND syntax and comparison tests

  • Each argument must evaluate to TRUE/FALSE — typically comparisons like A1>=100.
  • Text comparisons are case-insensitive in Excel by default.
  • AND ignores text and empty cells if passed directly — use comparisons instead.
  • Nested AND/OR: =AND(A2>0, OR(B2="X", B2="Y")).

Step-by-step: approve row only when all rules pass

  • Step 1 — Amount in C2, Status in D2, Date in E2.
  • Step 2 — Rules: amount > 0, status "Approved", date not blank.
  • Step 3 — =AND(C2>0, D2="Approved", E2<>"").
  • Step 4 — Flag: =IF(AND(...), "Pay", "Hold").
  • Step 5 — For many rules consider [IFS](/functions/ifs/) or helper checklist columns.

AND vs multiply trick vs nested IF

  • AND — readable; returns TRUE/FALSE clearly.
  • Legacy (A>0)*(B>0) — numeric 1/0 coercion; avoid in new models.
  • Nested IF — harder to read when many branches share AND logic.
  • Compare: [IF vs IFS](/compare/if-vs-ifs/) for multi-outcome models.

Worked examples to copy

  • Range check: =AND(A2>=1, A2<=100).
  • Date window: =AND(A2>=start, A2<=end).
  • With IF: =IF(AND(B2="Yes", C2>0), C2*0.1, 0).
  • Validation helper: =AND(LEN(A2)>0, ISNUMBER(B2)).

People also ask

  • AND vs & symbol? — AND is logical; & concatenates text — different functions.
  • AND with text TRUE/FALSE strings? — Use comparisons; string "TRUE" is not logical TRUE.
  • AND all blank arguments? — Returns TRUE if no FALSE found among evaluated args.
  • AND in conditional formatting? — Use same AND(...) as formula rule.

Common errors

  • Returns FALSE if any condition is FALSE
  • Text values are ignored unless in logical expressions

Use cases

  • Multiple condition validation
  • Data filtering criteria
  • Conditional formatting rules

Frequently asked questions

  • How does AND function work in Excel? AND returns TRUE only if ALL conditions are TRUE. If any condition is FALSE, AND returns FALSE. Example: =AND(A1>10, B1<20, C1="Yes") is TRUE only when A1>10 AND B1<20 AND C1 equals "Yes". It's commonly used inside IF for multiple criteria.
  • How do I use AND with IF? Nest AND inside IF's logical test: =IF(AND(condition1, condition2), "Yes", "No"). Example: =IF(AND(Score>=70, Attendance>=80%), "Pass", "Fail") requires both conditions to be true for "Pass".
  • What is the maximum number of conditions in AND? AND supports up to 255 conditions. However, for readability, consider breaking very long AND statements into helper columns or using a different approach like a criteria table with SUMPRODUCT.
  • How is AND different from OR? AND requires ALL conditions to be TRUE. OR requires at least ONE condition to be TRUE. =AND(TRUE, FALSE) returns FALSE. =OR(TRUE, FALSE) returns TRUE. Use AND for strict requirements; use OR for flexible alternatives.
  • Can AND check if a value is between two numbers? Yes: =AND(A1>=10, A1<=20) checks if A1 is between 10 and 20 inclusive. This is the standard way to check ranges in Excel. Combine with IF: =IF(AND(A1>=10, A1<=20), "In Range", "Out of Range").

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use AND

  • Multiple condition validation — common Logical scenario for AND.
  • Data filtering criteria — common Logical scenario for AND.
  • Conditional formatting rules — common Logical scenario for AND.

AND in the Logical category

  • Browse all Logical functions at /categories/logical/ for related formulas.
  • AND syntax: =AND(logical1, [logical2], ...)
  • logical1 (required): First condition to evaluate
  • logical2 (optional): Additional conditions (up to 255)
  • Confirm AND arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm AND arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • OR (/functions/or/): Returns TRUE if any argument is TRUE; returns FALSE only if all arguments are FALSE.
  • NOT (/functions/not/): Reverses the logic of its argument. Returns FALSE if argument is TRUE, and TRUE if argument is FALSE.
  • IF (/functions/if/): Returns one value if a condition is TRUE and another value if it's FALSE.
  • IFS (/functions/ifs/): Checks multiple conditions and returns a value corresponding to the first TRUE condition.
  • XOR (/functions/xor/): Returns TRUE if an odd number of arguments are TRUE (exclusive OR).

Comparisons involving this function

  • IF vs IFS (/compare/if-vs-ifs/): Use IF for one condition with two outcomes. Use IFS when you need three or more ordered conditions without building a hard-to-read nested IF chain.

Errors to watch for

  • Returns FALSE if any condition is FALSE — review causes on linked error pages in the directory.
  • Text values are ignored unless in logical expressions — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter AND on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

AND worked examples to copy

  • =AND(A1>0, A1<100) — Check if value is between 0 and 100. Expected result: TRUE or FALSE.
  • =IF(AND(B1="Yes", C1>50), "Approved", "Pending") — Multiple criteria check. Expected result: Approved or Pending.

AND reference summary for crawlers and offline review

  • AND belongs to the Logical category in Excel. Returns TRUE if all arguments are TRUE; returns FALSE if any argument is FALSE.
  • Full syntax: =AND(logical1, [logical2], ...). Open /functions/and/ for parameters, FAQs, and related pages.
  • Common mistakes: Returns FALSE if any condition is FALSE; Text values are ignored unless in logical expressions
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.