Better Sheets

How to Use OR() in Google Sheets

Description

Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.

How To Actually Use OR() in Sheets

OR(logical_expression1, [logical_expression2, ...])

Try OR yourself

In cells A1:A10, enter some TRUE or FALSE values. In cell B1, create a formula using OR to check if any of the values in A1:A10 are TRUE. The formula should return TRUE if at least one value is TRUE, and FALSE otherwise.

Your formula

Hints (2)

Locale Separator ,

Official Docs

3 Better Sheets Tutorials

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Data validation Advanced

IFS() NOT() OR()

5 Ways to use IF() Formula to Create Magic in Your Sheets

We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.

Intermediate

AND() IF() IFS() ISBLANK() OR() +1 more

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.

Beginner

AND() IF() OR()

Transcript-matched member videos for OR(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bet...

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Data Validation with Formulas

The issues you might run into validating data and 4 formulas you can use...

Intermediate

IF() ISBLANK() ISFORMULA() ISTEXT() ISURL()

Unlock these tutorials

Learn more about the OR() formula:

Generate a OR() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses OR(). 2 free AI generations, no signup. Members get unlimited use.

Generate a OR() formula

How to Use OR() in Google Sheets

Try OR yourself

Create a Radio Button From Checkboxes Using Google Apps Script

5 Ways to use IF() Formula to Create Magic in Your Sheets

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

More related tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Learn Google Sheet Formulas The Hard Way

Calculate ROAS in Google Sheets

Data Validation with Formulas