# Excel OR – an explanation of this useful function

The OR function can be found in Excel under the logical functions. It can be used to check simple conditions for their logical value - up to 255 conditions in total. Whether you are calculating bonuses or sales commissions, the OR function is an essential part of the data analysis program in the [Microsoft 365](https://www.ionos.co.uk/digitalguide/e-mail/technical-matters/what-is-microsoft-365/) package. In this guide, we will show you how to best use this function.

## Excel OR function – an explanation of the syntax

The OR function is particularly useful **in conjunction** with the IF function. While the [AND function](https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/excel-and-function/ "Excel AND function") checks whether all the conditions of an analysis are TRUE, the OR function checks whether one or multiple conditions are **TRUE or FALSE**. First, let us take a look at the general structure. As with every Excel function, the OR function has its own syntax.

```none
=OR(logical1)
```

In the following example, the function has only one argument. The function **always requires** at least one argument. You can add more arguments if needed. In the following example, the function will check whether the value of cell A1 (here 1) is larger than that of B1 (here 2). The syntax is as follows:

```none
=OR(A1>B1)
```

[![Image: Excel OR function with a simple argument](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/f/6/csm_excel-or-1_cc9abaac60.webp "Excel OR function with a simple argument")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/excel-or-1.png) Excel OR function with a simple argument Since this is not true, the function outputs the return value FALSE.

Note The operators for OR function arguments are always the characters \[>\],\[<\] and \[=\].

The OR function can analyse **up to 255 arguments**. So, to get the most out of the function, you should provide it with a set of arguments which it can check simultaneously. In the following example, all you need to do is apply the function used for the cell pair A1, B1 to a series of cells. To do so, click on the cell with the OR function (C1 in this example) and drag the **small green fill box** from the corner to the end of the column for the logical values (here for A1 to A4 and B1 to B4).

[![Image: Extending the Excel OR function to multiple cells](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/9/2/csm_excel-or-2_5d8abeea17.webp "Extending the Excel OR function to multiple cells")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/excel-or-2.png) Extending the Excel OR function to multiple cells [![Image: OR function in multiple cells](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/3/d/csm_excel-or-3_dd0d91de78.webp "OR function in multiple cells")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/excel-or-3.png) OR function in multiple cells ## The Excel OR function explained using simple examples

Now that you are familiar with the structure and use of the function, you will find that it is easy to check multiple arguments at the same time. When checking multiple arguments, the OR function looks like this:

```none
=OR(logical1;logical2)
```

Multiple arguments can be strung together using **commas** and no spaces. Depending on the region, you may need to use a semicolon instead of a comma.

The condition **A1>B1** is now followed by the condition **A1=B1**. A1 is greater than **OR** equal to B1.

[![Image: Excel OR function with multiple conditions](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/0/c/csm_excel-or-4_45b6402c2f.webp "Excel OR function with multiple conditions")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/excel-or-4.png) Excel OR function with multiple conditions If you want to include text when evaluating a condition, always place it in **double quotation marks** in the syntax of the function. The OR function will then be able to check whether “Saturday” “or Sunday” appear in a column containing weekdays.

[![Image: Excel OR function with multiple conditions in the form of text](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/f/d/csm_excel-or-5_f1b06a7aa4.webp "Excel OR function with multiple conditions in the form of text")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/excel-or-5.png) Excel OR function with multiple conditions in the form of text ## Combining the Excel OR function with the IF function

Values like TRUE and FALSE can be too abstract when using the OR function. To define what value should appear in the output cell, you can combine this function with the **IF function**. Using this combination is essential for the OR function to be able to serve its actual purpose and helps define the return values more precisely.

Tip The [IF function](https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/excel-if-then-statements/ "Excel if-then statements") can be useful in a variety of situations when using Excel.

The syntax of the combination of the IF and OR functions looks like this:

```none
=IF(OR(logical1;logical2);“Yes”;“No”)
```

This can be clearly illustrated using the example with the days of the week. Naturally, you can define the return values yourself: “Yes” and “No” in this example.

[![Image: Excel OR function with user-defined return values](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/5/f/csm_excel-or-6_920560a971.webp "Excel OR function with user-defined return values")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/excel-or-6.png) Excel OR function with user-defined return values ## A practical example of the OR function

To illustrate the practical use of the OR function, we will provide you with a concrete example. For the sake of clarity, you will enter the relevant parameters in the Excel spreadsheet. This is easy to illustrate using the days of the week. The evaluation of the logical values determines whether it is a weekday. The return values should indicate whether it is the weekend.

[![Image: Excel OR function with user-defined categories](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/b/1/csm_excel-or-7_49f7304fdc.webp "Excel OR function with user-defined categories")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/excel-or-7.png) Excel OR function with user-defined categories For our example, let us consider a **regional daily newspaper**. The newspaper would like to provide readers with a reward to celebrate its anniversary. However, there are **three criteria** to determine who gets a present. Only those who have had an uninterrupted subscription for more than ten years **OR** who live in the area (Berlin in this example) **OR** who have bought a special offer anniversary subscription will receive a gift. Only one of these criteria needs to be TRUE to receive a present.

Using the simple OR function, it looks like this:

[![Image: Excel OR function with user-defined categories](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/7/6/csm_excel-or-8_702dd52551.webp "Excel OR function with user-defined categories")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/excel-or-8.png) Excel OR function with user-defined categories All subscribers in the example who meet at least one of the criteria will receive a gift. Since the example subscriber Doris has not been a subscriber for ten years, does not live in Berlin, and has not purchased a special offer subscription, she will not receive a gift.

To avoid receiving **TRUE** or **FALSE** as the return value, you combine the function described above with the IF function and define the return values yourself. In this example, the return values are either “Present” if one of the criteria has been met or “-” if no criteria has been met.

[![Image: Excel OR function in practice](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/2/b/csm_excel-or-9_11e8aa3e77.webp "Excel OR function in practice")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2020/excel-or-9.png) Excel OR function in practice


This is a markdown version of: [https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/excel-or-function/](https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/excel-or-function/) for AI/LLM consumption.