Formulas > =OR()
How To Use OR() Function in Google Sheets
Description
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.
Hints (2)
-
Remember to use the OR function with the correct range.
-
Think about what the OR function does with TRUE and FALSE values.
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.
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.
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.
AND()
IF()
OR()
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