AND Function in Excel, Google Sheets, Airtable & Notion
AND returns TRUE when all of its conditions are TRUE and FALSE if any one of them is FALSE. It is usually used inside IF.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | AND(logical1, [logical2], ...) |
| Google Sheets | ✔ Built in | AND(logical_expression1, [logical_expression2, ...]) |
| Airtable | ✔ Built in | AND(expression1, [expression2, ...])Returns 1 or 0; format the field as a checkbox to show a tick. |
| Notion | ✔ Built in | and(condition1, condition2)Also written with the keyword: a and b, which chains easily: a and b and c. |
| Excel | =AND(34 >= 18, 34 <= 65) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =AND(34 >= 18, 34 <= 65) | open sheets.new ↗ |
| Airtable | AND(34 >= 18, 34 <= 65) | |
| Notion | and(34 >= 18, 34 <= 65) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
This is the standard "is it between min and max?" test. Both ends are inclusive.
Arguments
| Argument | What it means |
|---|---|
logical1 | The first condition, such as B2>=18. |
[logical2], ... optional | More conditions. Excel accepts up to 255. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=AND(34>=18, 34<=65) | TRUE | Both conditions hold. | |
=AND(TRUE, FALSE) | FALSE | One FALSE is enough. | |
=IF(AND(B2>0, C2="Paid"), "Ship", "Hold") | "Ship" or "Hold" | The usual pattern: AND inside IF. |
Examples use Excel / Google Sheets syntax unless noted.
How AND works
AND is how you require several things at once: an order is paid and in stock, a date is after the start and before the end, a score is within a range. On its own it returns TRUE or FALSE; wrapped in IF it drives a decision: =IF(AND(B2>=18, B2<=65), "Eligible", "Not eligible").
A common mistake is writing a range test the way you would on paper: =18<=B2<=65 does not work in any spreadsheet. Split it into two comparisons inside AND. In Excel and Google Sheets, AND ignores empty cells and text inside ranges but returns #VALUE! if there is nothing logical to test at all.
Airtable's AND() works the same way and returns 1 or 0. In Notion you can call and(a, b) or use the keyword form prop("Paid") and prop("Qty") > 0. To require only one of several conditions, use OR.
Frequently Asked Questions
- How do I check if a value is between two numbers?
- Use
=AND(B2>=10, B2<=20). Use>and<instead if the end points should be excluded. - Can I use AND in conditional formatting?
- Yes. A custom formula rule such as
=AND($B2>=10, $B2<=20)highlights rows where B is between 10 and 20.