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
Generic Formula:
- Use the below formula to test the multiple cells based on non-blank conditions.
=IF(A1<>””,A1,IF(B1<>””,B1,IF(C1<>””,C1,IF(D1<>””,D1,”No Value”))))
Syntax Explanations:
- IF – In Excel, the IF function helps to return one value for a TRUE result, and another for a FALSE 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.
- Here, we need to check the cells and find out the first non-blank value.
- Apply the above-given formula to the formula bar section and press the “Enter” key.
- It will display the result as per the below image.
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 **and Excel Formulas *!! **
Top comments (0)