# OR

The `OR` 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:

Parameters:
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

Here are a few example use cases that explain how to use the `OR` 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 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.

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.

You can learn more about the `OR` Google Sheets function on Google Support.