You can use the following basic syntax in Google Sheets to use the **FILTER** function with **OR** logic:

=FILTER(A1:C10, (A1:A10="A")+(C1:C10<20))

This filter returns the rows in the range A1:C10 where the value in column A is equal to “A” **or **the value in column C is less than 20.

**Note**: The plus (**+**) sign is used as an OR operator in Google Sheets.

The following example shows how to use this syntax in practice.

**Example: How to Use Filter Function with OR in Google Sheets**

Suppose we have the following dataset in Google Sheets that contains information about various basketball players:

We can use the following formula to filter for all rows where the team is equal to “A” **or **the points is less than 20:

=FILTER(A1:C10, (A1:A10="A")+(C1:C10<20))

The following screenshot shows how to use this formula in practice:

The only rows returned are the ones where the team is equal to “A” **or** the points is less than 20.

We can also use more plus signs (**+**) in the **FILTER** function to apply even more **OR** operators.

For example, we can use the following syntax to filter for rows where the team is equal to “A” **or **the position is “Guard” **or** points is greater than 15:

=FILTER(A1:C10, (A1:A10="A")+(B1:B10="Guard")+(C1:C10>15))

The following screenshot shows how to use this formula in practice:

This **FILTER** function returns the rows in the original dataset where any of the three conditions are met.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: How to Filter for Cells that Contain Text

Google Sheets: How to Use SUMIF with Multiple Columns

Google Sheets: How to Sum Across Multiple Sheets