# AND function in Excel

> AND returns TRUE only when every condition you give it is TRUE.

Source: https://spreadsheetpractice.com/functions/and · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** AND returns TRUE only when every condition you give it is TRUE.
- **Syntax:** `=AND(logical1, [logical2], ...)`
- **Most common use:** `=AND(B2>=80,C2>=2)` returns TRUE (Both conditions are met, so TRUE)
- **Available in:** Every current version
- **Category:** [Logical functions](https://spreadsheetpractice.com/functions/category/logic)
- **Returns:** TRUE if every argument is TRUE, FALSE if any one is FALSE.
- **Google Sheets:** Works the same way in Google Sheets.

## What it does

AND returns TRUE only when every condition you give it is TRUE. On its own it just answers TRUE or FALSE, so it is usually the test inside an IF: approve an order only if it is paid and in stock, or invite a candidate only if the score and the references both clear the bar.

## Syntax

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

| Argument | Required? | What it is |
|---|---|---|
| `logical1` | Required | The first condition, such as B2>=80. |
| `logical2` | Optional | More conditions, up to 255 in total. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=AND(B2>=80,C2>=2)` | TRUE | Both conditions are met, so TRUE |
| D3 | `=AND(B3>=80,C3>=2)` | FALSE | One condition fails, so the whole result is FALSE |
| D4 | `=IF(AND(B4>=70,C4>=2),"Interview","Decline")` | Interview | Inside IF to return a label |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Applicant | Score | References | Result |
| 2 | Rivera | 82 | 2 | TRUE |
| 3 | Chen | 91 | 1 | FALSE |
| 4 | Patel | 76 | 3 | Interview |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Using AND for "either" rules | AND needs every condition to be TRUE. If any one condition should be enough, use OR. |
| Writing a between test the math way | =AND(10<B2<20) doesn't work. Give each comparison its own argument: =AND(B2>10,B2<20). |
| #NAME? | Text conditions need quotes: AND(C2="Paid",D2="Shipped"). |

## Tips

- To apply AND across many rows at once, such as inside SUMPRODUCT or FILTER, multiply the conditions instead: (B2:B9>=80)*(C2:C9>=2).

## Related functions

- [OR](https://spreadsheetpractice.com/functions/or): OR returns TRUE when at least one of its conditions is TRUE.
- [NOT](https://spreadsheetpractice.com/functions/not): NOT flips a logical value: TRUE becomes FALSE and FALSE becomes TRUE.
- [XOR](https://spreadsheetpractice.com/functions/xor): XOR returns TRUE when an odd number of its conditions are TRUE.
- [IF](https://spreadsheetpractice.com/functions/if): IF checks a condition and returns one value when it is true and another when it is false.

## Questions

### How do I use IF with AND?

Make AND the first argument of IF: =IF(AND(B2>=80,C2>=2),"Yes","No"). Both conditions must be TRUE to get "Yes".

### How do I check if a number is between two values?

Use AND with two comparisons: =AND(B2>=10,B2<=20).

## Practice

A graded AND exercise ("Promotion eligibility") is on [the AND page](https://spreadsheetpractice.com/functions/and). It is checked instantly, then re-checked on changed data.

Lessons that use AND:

- [Lesson 6: AND, OR & IFS](https://spreadsheetpractice.com/learn/and-or-ifs)
- [Lesson 45: Capstone: analyst interview test](https://spreadsheetpractice.com/learn/capstone-analyst-interview) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
