Excel Formulas to Test Multiple Cells and Return Non-Blank Value!!
Tags: excelformula, excelformulas
Published: 2021-02-24 11:37:27

---
title: Excel Formulas to Test Multiple Cells and Return Non-Blank Value!!
published: true
date: 2021-02-23 12:09:42 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-multiple-cells-and-return-non-blank-value/
---

In Excel, most of the time we don’t want to work with blank cells. Because it creates errors while using the formula. But sometimes you may need to **check the multiple cells and return the value from the first non-blank cell**. How could you deal with this task in Excel? This article provides some simple formulas to help you quickly get it done. 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 not blank multiple cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/If-not-blank-multiple-cells.png)](https://geekexcel.com/excel-formulas-multiple-cells-and-return-non-blank-value/if-not-blank-multiple-cells/#main)<figcaption id="caption-attachment-22082">If not blank multiple cells</figcaption>
## Generic Formula:

- Use the below formula to test the multiple cells based on non-blank conditions.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(A1<>””,A1,IF(B1<>””,B1,IF(C1<>””,C1,IF(D1<>””,D1,”No Value”))))**

## 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.
- **Test Values (A1, B1, C1, D1)**– It is the input data from your worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Not Equal to (<>)** – In Excel, the <> symbol represents the non-blank value.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example. Here we are going to test the cells based on non-blank values.

- For instance, we have the input values in **Column B** to **Column E** shown in the below image.

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

- Here, we need to check the cells and find out the first non-blank value.
- 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 the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Enter-the-formula-22.png)<figcaption id="caption-attachment-22080">Enter the formula</figcaption>

- It will display the result as per the below image.

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

## Wrap-Up:

This is how we have tested the cells and return the non-blank value in Excel. If you have any issue **regarding** this article or any **unresolved query** , please **comment** in the comment box below. We will assist you. To learn more, check out  **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Formulas for Counting Non-Contiguous Range in Excel Using COUNTIF!!](https://geekexcel.com/formulas-for-counting-non-contiguous-range-in-excel-using-countif/)**
- **[Excel Formulas to Check If the Cell is Blank or Not!!](https://geekexcel.com/excel-formulas-to-check-if-the-cell-is-blank-or-not/)**
- **[Select Non-Blank or Non-Empty Cells in a Range in Excel Office 365!!](https://geekexcel.com/select-non-blank-or-non-empty-cells-in-a-range-in-excel-office-365/)**