Excel Formulas to Check If the Cell is This or That with OR Function!!
Tags: excelformula, excelformulas
Published: 2021-02-20 10:18:43

---
title: Excel Formulas to Check If the Cell is This or That with OR Function!!
published: true
date: 2021-02-20 06:28:23 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-check-if-the-cell-is-this-or-that-with-or-function/
---

One of the most common tasks in Excel is checking whether a cell contains a given value or not. If you want to do something specific **when a cell equals either this or that** , you can use the **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** along with the **[OR function](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/)** in Excel. In this article, we will provide some cute formulas to solve this problem. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

![If cell contain this or that](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/If-cell-contain-this-or-that.png)<figcaption id="caption-attachment-22005">If cell contains this or that</figcaption>
## Generic Formula:

- Use the below formula to find if the cell value is equal to this or that.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([OR](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/)(A1=”this”,A1=”that”),”x”,”y”)**

## Syntax Explanations:

- **IF** – In Excel, the **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** helps to return one value for a **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** result.
- **OR** – It is a logical function to test multiple conditions at the same time. The **[OR Function](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/)** helps to return either **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** or **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)**.
- **A1** – It is the input data from your worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- First, we will enter the input values in **Column B**.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Input-Ranges-17.png)<figcaption id="caption-attachment-22007">Input Ranges</figcaption>

- Then apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Enter-the-formula-19.png)<figcaption id="caption-attachment-22008">Enter the formula</figcaption>

- Finally, it will display the result as per the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Result-22.png)<figcaption id="caption-attachment-22004">Result</figcaption>

## Conclusion:

From this short tutorial, we have described the simple formula used to **find if the cell is equal to this or that in Excel** by using the **IF function** along with the **OR function**. If you have any doubts, let me know in the below **comment** box. Thank you so much for visiting our site!! Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Check If Cell Contains All Values from a Range in Excel Office 365!!](https://geekexcel.com/check-if-cell-contains-all-values-from-a-range-in-excel-office-365/)**
- **[Excel Formulas to Match Occurrence Does not begin with Specific Value!!](https://geekexcel.com/excel-formulas-match-occurrence-does-not-begin-with/)**