Excel OR Function | Most useful Excel functions

5.4 min read|Last Updated: February 11th, 2024|Categories: excel|
table of content

When working with Excel, sometimes you need to decide whether to perform an action or not. In these cases, Excel logical functions come in handy.

OR is one of these functions, and we are going to discuss it in this tutorial.

Excel Logical Functions

First things first, let’s see what logical functions are in Excel and what they do.

We use the logical functions in Excel to test whether a condition is true or false. They allow us to check a cell’s content or perform an action such as a calculation or further tests.

Excel provides eleven logical functions. Some of these functions check if a condition is true or false and return either TRUE or FALSE; some can take a command such as a formula to run based on the conditions. They can also combine multiple conditions.

Excel OR Function

Excel OR function is a basic logical function that is used to compare two or more conditions. Like the other logical functions, it returns either TRUE or FALSE. Now, let’s see how it works.

The syntax of the function is as below:

=OR(logical1, [logical2], …)

As you can see in the function’s syntax, it takeslogical values as input arguments. In fact, the arguments are conditions in a test which we want to compare.

If at least one of the conditions is TRUE, the OR function returns TRUE as the result. Otherwise, it returns FALSE.

Helpful Notes about the OR Function

  1. Like the other logical functions in Excel, the OR function can take numbers as input arguments. It evaluates zero as FALSE and other numbers as TRUE.
  2. The function ignores empty cells if used as input arguments.
  3. If the function cannot evaluate an argument as a logical value, it returns the VALUE error.

Example: look at the image below to see how the function works:

How to use the OR function in Excel

OR as an Array Formula

Sometimes, you need to compare a large number of cells. In this case, you have to use OR in an array formula.

Imagine you have a dataset of growth percentage in your products’ prices, and you want to know if any of them has grown at least 90%.To find this out, type “=OR(D2:D15>=90)” and press Alt+Ctrl+Enter.

How to use the OR function as an array formula in Excel

Note: If you do not enter the formula as an array formula, the function will return FALSE unless you type it in the same row as the cell that