How do I get an OR result for every row in Google Sheets?

Add the tests together and compare the sum with 0, because the plus sign works element by element inside ARRAYFORMULA.

Google Sheets function

OR in Google Sheets

OR also collapses a range into a single answer in Google Sheets, even when it sits inside ARRAYFORMULA.

OR(logical1, logical2, …)

Add the conditions together for a row-wise result, as in ARRAYFORMULA((A2:A9="East")+(A2:A9="West")>0).

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

	A	B
1	Score	Override
2	65	Yes

Formula: D2: =OR(A2>=70,B2="Yes")

Result: TRUE

The override makes the result true even though the score is low.

	A	B
1	Score	Override
2	65	No

Formula: D2: =OR(A2>=70,B2="Yes")

Result: FALSE

Both alternatives are false.

	A
1	Region
2	West

Formula: C2: =OR(A2="East",A2="West")

West matches one of the two accepted regions.

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

Formula in F2: =OR(B2>=90,C2="Yes")

Result in F2: TRUE

How do I get an OR result for every row in Google Sheets?: Add the tests together and compare the sum with 0, because the plus sign works element by element inside ARRAYFORMULA.

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