Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inAND(logical1, [logical2], ...)
Google Sheets✔ Built inAND(logical_expression1, [logical_expression2, ...])
Airtable✔ Built inAND(expression1, [expression2, ...])
Returns 1 or 0; format the field as a checkbox to show a tick.
Notion✔ Built inand(condition1, condition2)
Also written with the keyword: a and b, which chains easily: a and b and c.
Try AND with your own values
Result (as Excel & Google Sheets return it)
TRUE
Your formula, ready to paste
Excel=AND(34 >= 18, 34 <= 65) open excel.new ↗
Google Sheets=AND(34 >= 18, 34 <= 65) open sheets.new ↗
AirtableAND(34 >= 18, 34 <= 65)
Notionand(34 >= 18, 34 <= 65)

This is the standard "is it between min and max?" test. Both ends are inclusive.

Arguments

ArgumentWhat it means
logical1The first condition, such as B2>=18.
[logical2], ... optionalMore conditions. Excel accepts up to 255.

Examples

FormulaResultWhyCopy
=AND(34>=18, 34<=65)TRUEBoth conditions hold.
=AND(TRUE, FALSE)FALSEOne 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.

Part of the Logical functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.