In this article, I have explained to you, how to use the IFERROR Excel Function in Excel with other Excel Formulas and Functions Like IFERROR with VLOOKUP, IFERROR with HLOOKUP, IFERROR with Simple Divide Formula, and IFERROR with IF. So let’s start.

Contents

IFERROR Excel Function

The feature of the “IFERROR” function

Explanation of IFERROR Function

Example of Explanation of IFERROR Function: –

Solution:

Download the Practice workbook for the IFERROR Function

IFERROR Excel Function

The IFERROR Excel Function can be used with other Excel functions. The IFERROR function shows the already given sentence when there is an error in the result of other functions or formulas of Excel. Error in result such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL.

We can use this function where we know that the function will generate errors in some cases. Suppose, you have created the formula of dividing two cell values with each other but for the time being, these cells don’t have any value. Then The result will show an error of #DIV/0!. So if you use the formula with the IFERROR function then you can remove this result with your predefined text or blank. Now the question is how? In this article, I will explain to you how you can use the IFERROR Function with other Excel formulas and Functions.

The feature of the “IFERROR” function

IFERROR will find results until it gets an error.
With the help of the IFERROR Function, we can make our project neat and clear by replacing errors with predefined text or Blank Cells.
It removes/Replaces Excel errors only which are logical errors, not human errors.
It can be used with all other functions of Excel.
Errors evaluated by IFERROR Function are N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL.

Explanation of IFERROR Function

Now, We will explain the Arguments of the Function.

=IFERROR(value, value_if_error)

value:- Select the value on which you want to apply the error rule. You can select the cell or write the already applied formula here.

value_if_error: – You have to write the value that you want to show if there is an error in the applied function. it can be yes, no, 1,0, blank, etc. whatever you want to show.

The following errors are evaluated by this formula:
#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL.

Example of Explanation of IFERROR Function: –

In the following table, we want to retrieve the result of the price of the product without any error message. The table of date-wise sales is given in the workbook.

Explanation of IFERROR Function in Excel - 1 — Explanation of IFERROR Function in Excel – 1

Solution:

We will Apply the IFERROR function and get the result. This is shown in the following steps: –

Step No. 1:-

We will write the “=IFERROR( ” in the column of the result

Explanation of IFERROR Function in Excel 2 min — Explanation of IFERROR Function in Excel – Step no.1

Step No. 2

Now select the value(function) from which you want to check the errors. Like I am coping already applied the formula of VLOOKUP in column E and pasted it in the value part of the IFERROR Function.

Explanation of IFERROR Function in Excel 3 min — Explanation of IFERROR Function in Excel – Step no.2

you can also write the new formula or any calculation formula that you are using while calculating something.

Step No. 3: –

Now please select the value_if_error that will be shown when there is an error in the selected function.

I have just written 0 because I want the value of 0 only. You can write any message here but if you want to use text then use it within inverted commas like “your text”.