OR
TheOR
formula is a logical formula that returns TRUE if at least one of the provided logical expressions is TRUE. It returns FALSE if all logical expressions are FALSE. This formula is commonly used in conjunction with other logical formulas, such as AND
, to build more complex logical statements.
Usage
Use the OR
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 logical_expression1 (required):
The first logical expression to evaluate. It can be a reference to a cell containing a logical value, a formula that returns a logical value, or a logical value itself.  logical_expression2, ... (optional):
Optional. Additional logical expressions to evaluate. You can include up to 255 logical expressions separated by commas. Each expression can be a reference to a cell containing a logical value, a formula that returns a logical value, or a logical value itself.
Examples
Here are a few example use cases that explain how to use theOR
formula in Google Sheets.
Checking if any value in a range meets a certain criteria
You can use the OR
formula to check if any value in a range meets a certain criteria. For example, you can use the formula =OR(A1:A10="Pending")
to check if any cell in the range A1:A10 contains the text "Pending".
Building more complex logical statements
You can use the OR
formula in combination with other logical formulas, such as AND
, to build more complex logical statements. For example, you can use the formula =AND(OR(A1="Yes",A1="Y"),B1>0)
to check if cell A1 contains the text "Yes" or "Y" and cell B1 is greater than 0.
Common Mistakes
OR
not working? Here are some common mistakes people make when using the OR
Google Sheets Formula:
Missing arguments
One or more arguments are missing from the OR formula. Make sure to include at least one logical expression.
Using nonlogical values
The OR formula only works with logical values such as TRUE or FALSE. Make sure to use logical expressions as arguments.
Incorrect syntax
Make sure to use the correct syntax for the OR formula. The logical expressions should be separated by commas and enclosed in parentheses.
Related Formulas
The following functions are similar to OR
or are often used with it in a formula:

AND
The
AND
function in Google Sheets is a logical function that returns TRUE if all of the logical expressions in the argument are TRUE, and FALSE if any of the logical expressions are FALSE. It can be used to test multiple conditions and evaluate whether they are all true or not. 
NOT
The
NOT
formula in Google Sheets is a logical function that negates a given logical expression. If the logical expression evaluates to TRUE, the formula returns FALSE, and vice versa. This function is commonly used to reverse the result of a logical test, or to check if a value is not equal to a specific criteria. 
IF
The
IF
formula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions. 
SWITCH
The
SWITCH
formula is a logical function in Google Sheets that allows you to evaluate an expression against a list of cases and corresponding values. If the expression matches a case, the formula returns the corresponding value. If there is no match and a default case is specified, the formula returns the value for the default case. This function is commonly used for conditional formatting, data validation, and other tasks that require evaluating multiple conditions.
Learn More
You can learn more about the OR
Google Sheets function on Google Support.