How to Use Excel IFERROR Function?

Ads

Listen to this article

In Excel, we can use functions and formulas to perform mathematical operations. Excel Offers spreadsheets to store, organize, or perform operations with formulas and functions. Sometimes, we want to get the custom result when the error has occurred on the worksheet, then we can use the Excel IFERROR function.

In this post, we will show you the clear-cut steps to know how to use the Excel IFERROR function in the worksheet with examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

Syntax

Here, you will see the syntax of the IFERROR function.
To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
Once you enter the formula, click the Enter button to get the result.

=IFERROR(value, value_if_error)

Argument Description:

value – It refers to the input value or reference or formula check for an error.
value_if_error – When an error is found, it will return this specified value.

Note:
1) If the value argument is empty, it doesn’t throw an error. But it is evaluated as an empty string.
2) If value_if_error is given as an empty string, you will not see any message when an error is found.

What will IFERROR Function Do?

IFERROR is one of the built-in functions in Microsoft Excel. It will return a custom result when a formula generates an error, and a standard result when no error is detected. If you are a regular spreadsheet user and want to manage your product details accurately without any errors, we suggest you use this function to prevent your worksheet from displaying errors.

For example, we have given a fruit shop billing details and here we are going to use the IFERROR function in order to find where the error occurs in the input range. We will calculate the total price of fruit that is sold. If there is no error in the applied formula, it will give the actual value, else returns “No“.

Now, we have to enter the following formula in the corresponding cell where you want to get the result.

=IFERROR(C3*D3,”No”)

Now, click on the Enter button to execute it and get the result. To fill the remaining cells in the range, you have to drag down the first cell to the last cell in the range. It will quickly autofill the results based on the given input values.

If you want to learn how this function works with simple examples, then move to the next section. You can find easy examples for quick understanding.

Alternate Examples

Let’s see examples to understand how to use the IFERROR Function.

Initially, you must open your Excel workbook on your PC and launch the worksheet with data.
For instance, we have given the input values in the range B2:D9, and we will get the output.

Then, you must enter the formula in the cell below to get the result.

After entering the formula, you need to click the Enter button to get the output.

Once you get the output for the first cell, then you need to drag down the cell to fill in the remaining values.

Citations

The IFERROR function will find out the error in the formula cells and display the specified value instead of showing the error. We can apply this function whenever we want not to show the error in the spreadsheet and to show the custom value in cells. We have understood the purpose of IFERROR logical expression with the help of the sites: Logical IFERROR^[1] and Excel IFERROR Function^[2].

Wind-Up

This page helped you to know how to use the Excel IFERROR function in the worksheet with its syntax and proper explanation. Drop your feedback in the below comment section. To learn more about Excel functions, then visit our webpage, Aawexcel.com.

If you want to know what people think about this IERROR Function of Excel, then we suggest you look for it on the Quora interaction webpage. From where you can get to know more regarding the Excel IERROR function. Here, we have provided the link to Quora’s official website: Use IFERROR Function.