Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelIfError in Depth in Microsoft Excel

# IfError in Depth in Microsoft Excel

In this post, letâ€™s learn about IFERROR function in depth in Microsoft Excel and see with an example on how use it with-in your Excel spreadsheet.

This function is used to detect and handle errors in Excel.

## IFError in Excel

The IfError finds errors in a formula and gives out the alternative result of the formula if an error occurs.

In case no error occurs in the formula then the function returns a different result. IfError is an easy way to find and handle the errors in a formula.

Syntax â€“ IFERROR(normal_value, value_if_error)

Note: If no argument is passed for normal_value then it is considered as empty and not incomplete, the same applies for value_if_error.

As mentioned above this function works in such a way that when an error is encountered it displays the value youâ€™ve passed as an argument and if not it displays the other value youâ€™ve passed.

IfError usually check for errors such as #N/A, #VALUE!, #REF!, #DIV/0, #NUM!, #NAME?, #NULL!.

Letâ€™s take a look at few examples.

Here the formula of SUM is correct so no error occurs and the value is displayed as of the formula.

In this case, an error occurs as A2 doesnâ€™t contain any value so the alternative value gets displayed.

This is a special case as mentioned above if you notice the function as an empty argument for the value of value_if_error. The function returns the value of SUM as it is correct. Now take a look at the example below.

Here the formula returns nothing as an error occurs so it returns the value_if_error which is empty.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021