OR

• How to use OR formula?
• Examples of using OR formula
• OR formula not working?
• Similar formulas to OR

Usage

Use the OR formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

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

1. 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.
2. 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

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

Missing arguments

One or more arguments are missing from the OR formula. Make sure to include at least one logical expression.

Using non-logical 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.