Aung Shine
Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel functions and features. Excel provides built-in functions and they help us on a daily basis. The IFERROR function is one of them. This function tests whether an expression is an error or not. In this article, we’ll show you 3 practical examples of the Excel IFERROR function to Return Blank Instead of 0.
Download Practice Workbook
Download the following workbook to practice by yourself.
Introduction to Excel IFERROR Function
The IFERROR function tests an expression to see whether it returns an error value. If the expression returns an error, it’ll give a specified output. But if the expression is not an error, it’ll return the value of the expression itself. The arguments are: value, value_if_error.
Here,
value: The expression that will be tested for an error.
value_if_error: The function will return this value if found error.
3 Useful Examples of Excel IFERROR Function to Return Blank Instead of 0
The IFERROR function is very effective when we have a large dataset that may contain error expressions. Using this function we can save a lot of time. Otherwise, we’d have to find the errors annually which is a tiresome job. This article will show examples of the IFERROR function to return blank instead of 0.
1. Return Blank Instead of 0 Using IFERROR with Some Formulas
In our first example, we’ll use IFERROR with a simple formula. To illustrate, we’ll use a sample dataset as an example. For instance, in the following dataset, we’ll divide the D5 cell value by the D6 cell value. But D6 is empty. So the division output will be an error. In this case, we’ll apply the IFERROR function to return a blank. Therefore, follow the steps below to perform the task.
STEPS:
- First, select cell C10.
- Then, type the formula:
=IFERROR(D5/D6, "")- Afterward, press Enter.
- Thus, it’ll return a blank cell.
- Look at the below picture to understand better.
Read More: How to Use XLOOKUP to Return Blank Instead of 0
Similar Readings
- How to Ignore Blank Series in Legend of Excel Chart
- How to Remove Zeros in Front of a Number in Excel (6 Easy Ways)
- How to Hide Rows with Zero Values in Excel Using Macro (3 Ways)
- How to Hide Chart Series with No Data in Excel (4 Easy Methods)
- How to Hide Zero Values in Excel Pivot Table (3 Easy Methods)
2. Combine Excel IFERROR & VLOOKUP Functions to Get Blank Instead of 0
The VLOOKUP function looks for a particular value in the specified range. Then, it retrieves a value from the mentioned column if the match is found. Here, we’ll combine IFERROR & VLOOKUP functions to get a blank instead of 0. In the following dataset, we’ll search for Wil in the range B5:D8. If it’s found in the range, we’ll retrieve the 3rd column value. Otherwise, it returns a blank cell. So, learn the steps to carry out the operation.
STEPS:
- Firstly, choose cell C10.
- Here, insert the formula:
=IFERROR(VLOOKUP(B10, B5:D8, 3,FALSE), "")- After that, press Enter.
- Hence, you’ll get a blank cell as Wil is not in the range.
Read More: How to Use VLOOKUP to Return Blank Instead of 0 (7 Ways)
3. Apply Nested IFERROR with VLOOKUP for Returning Blank In Excel
In our last example, we’ll use multiple IFERROR & VLOOKUP functions to form a nested formula. In the below dataset, we’ll search for Wil in the range B5:D6 and B8:D9. Hence, learn the process to perform the task.
STEPS:
- First of all, select cell C11.
- Type the formula:
=IFERROR(VLOOKUP(B11,B5:D6,3,0),IFERROR(VLOOKUP(B11,B8:D9,3,0),"" ))- Press Enter afterward.
- You’ll get the blank cell finally.
Read More: How to Apply VLOOKUP to Return Blank Instead of 0 or NA
Conclusion
Henceforth, you will be able to use the Excel IFERROR function to Return Blank Instead of 0 following the above-described examples. Keep using them and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.
