Syntax
=AND(logical1, [logical2, ...])
logical1- The first condition.
logical2, ...- Optional. More conditions or ranges of TRUE/FALSE values.
AND function in Google Sheets
AND returns TRUE only when every condition you give it is TRUE. It's mostly used inside IF to require several things at once.
Practice AND
Task 1 of 2
An applicant is approved if they are at least 21 AND have a credit score of 650 or more. Return TRUE/FALSE in D2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
AND examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Student | Class | Score | Passed |
| 2 | Priya | A | 92 | TRUE |
| 3 | Leo | B | 67 | FALSE |
| 4 | Chloe | A | 48 | FALSE |
| 5 | Mateo | B | 81 | TRUE |
| 6 | Ines | C | FALSE | |
| 7 | Kai | C | 75 | TRUE |
| Formula | Result | What it shows |
|---|---|---|
=AND(C2>=70, B2="A") | TRUE | Both are true for Priya. |
=AND(C3>=70, B3="A") | FALSE | Neither is true for Leo. |
=AND(D2:D7) | FALSE | Did everyone pass? Ranges of TRUE/FALSE work too. |
=IF(AND(C5>=80, B5="B"), "Star", "") | Star | Typical use inside IF. |
Tips and common mistakes
- Each condition must be a complete comparison. =AND(C2>=70, <=100) is invalid; write =AND(C2>=70, C2<=100).
Related functions
Learning step by step? AND is covered in Lesson 7: AND, OR, NOT & XOR of the free course.