Excel Formulas to Check If the Cell is Blank or Not!!
Tags: excelformula, excelformulas
Published: 2021-02-17 08:07:22

---
title: Excel Formulas to Check If the Cell is Blank or Not!!
published: true
date: 2021-02-17 06:00:33 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-check-if-the-cell-is-blank-or-not/
---

There are many ways available to find blank cells. In this tutorial, we will show the simple formulas used to check the cell and take some action **if the cell is blank**. 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 is blank](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/If-cell-is-blank.png)](https://geekexcel.com/?attachment_id=21959#main)<figcaption id="caption-attachment-21959">If the cell is blank</figcaption>
## General Formula:

- Use the below formula to test if the value of the cell is blank.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(A1=””,”blank”,”not blank”)**

## Syntax Explanations:

- **IF** – The Excel **[IF Function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** will help 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.
- **A1** – It represents the input value 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.

- Here, we will enter the input values in **Column B** and **Column C**.

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

- Now, we are going to test if the cell contains any value or empty and returns **“Pass”** or **“Fail”** based on the result.
- Apply the above-given formula to the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section and press the **“Enter”** key.

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

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

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

 

## Verdict:

From this tutorial, we have described the simple formula used to **check if the cell is blank or not in Excel**. Please feel free to share your thoughts in the below **comment** box. We will assist you. Thank you so much for visiting our site!! To learn more **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Get the First Non-blank Value from a range!!](https://geekexcel.com/excel-formulas-get-first-non-blank-value/)**
- **[Excel Formulas to Find the Minimum Difference ignore blank Cells!!](https://geekexcel.com/excel-formulas-minimum-difference/)**
- **[Formulas for Counting the Cells that are Blank in Excel Office 365!!](https://geekexcel.com/formulas-for-counting-the-cells-that-are-blank-in-excel/)**
- **[Formulas to Replace #N/A or Zero in Vlookup with Blank or Specified Text!!](https://geekexcel.com/formulas-to-replace-n-a-or-zero-in-vlookup-with-blank-or-specified-text/)**