Why does AND inside ARRAYFORMULA give one answer in Google Sheets?

AND collapses its inputs into one result. Multiply the conditions, which gives 1 or 0 for each row.

Google Sheets function

AND in Google Sheets

AND returns a single TRUE or FALSE for a range even inside ARRAYFORMULA, so it cannot test row by row.

AND(logical1, logical2, …)

For row-wise logic in Google Sheets multiply the conditions instead, such as ARRAYFORMULA((A2:A9>=70)*(B2:B9="Yes")).

For a fuller explanation of the arguments and common errors, see the AND Excel guide.

	A	B
1	Score	Attendance
2	82	95

Formula: D2: =AND(A2>=70,B2>=90)

Result: TRUE

Both the score and attendance thresholds pass.

	A	B
1	Score	Attendance
2	82	80

Formula: D2: =AND(A2>=70,B2>=90)

Result: FALSE

A single false condition makes the combined result false.

	A
1	Value
2	7

Formula: C2: =AND(A2>=1,A2<=10)

Seven is at least one and at most ten.

A tiny spreadsheet with example data. Edit the formula or any number and see the result.

Formula in F2: =AND(B2>=60,C2="Yes")

Result in F2: TRUE

Why does AND inside ARRAYFORMULA give one answer in Google Sheets?: AND collapses its inputs into one result. Multiply the conditions, which gives 1 or 0 for each row.

Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.