Excel function · Logic
AND
Returns TRUE only when every test is true.
What it does
AND checks two or more tests and returns TRUE if all of them are TRUE. It's most often used inside IF, to require several things at once.
Syntax
=AND(logical1, [logical2], …)Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,
Arguments
- logical
- A test that gives TRUE or FALSE. Add as many as you need.
Example
A good walking day is between 15 and 25 degrees. Is 21 degrees one?
| A | B | |
|---|---|---|
| 1 | Temp (°C) | Walking weather? |
| 2 | 21 | TRUE |
The formula in B2:
=AND(A2>=15,A2<=25)Result: TRUE
21 is at least 15 and at most 25, so both tests are TRUE and AND returns TRUE.
Common mistakes
- Writing a between test as one comparison, the way you would on paper. Excel needs two separate tests inside
AND. - Expecting a word as the answer.
ANDonly returns TRUE or FALSE; wrap it inIFto show Yes or No.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | AND | , |
| Deutsch | UND | ; |
| Français | ET | ; |
| Español (España) | Y | ; |
| Español (México) | Y | , |
| 日本語 | AND | , |
| 한국어 | AND | , |
| 繁體中文 | AND | , |
| ไทย | AND | , |
| ខ្មែរ | AND | , |
| Tiếng Việt | AND | ; |