# How to use Excel IFERROR function

## SUMMARY INFO

All the basic information regarding Excel IFERROR function is listed in the table below. (This data is regularly updated from Microsoft and several resources)

 Function: IFERROR Function Category: Logical Description: Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula Return Value: The value you specify for error conditions. Syntax: =IFERROR (value, value_if_error) Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007 Other languages: English: IFERROR French: SIERREUR German: WENNFEHLER Spanish: SI.ERROR Dutch: ALS.FOUT Italian: SE.ERRORE Russian: ЕСЛИОШИБКА Danish: HVIS.FEJL Swedish: OMFEL Portuguese (Brazil): SEERRO Polish: JEŻELI.BŁĄD Finnish: JOSVIRHE Norwegian: HVISFEIL Portuguese (Portugal): SE.ERRO Czech: CHYBHODN Hungarian: HAHIBA Turkish: EĞERHATA All Other Languages: IFERROR Related Functions: IF, AND, OR

## FUNCTION DETAILS

Syntax details with an example regarding the correct usage of IFERROR formula in Excel can be seen below.

### =IFERROR (value, value_if_error)

value The value, reference, or formula to check for an error.
value_if_error The value to return if an error is found.

## VIDEO EXAMPLES

Check the video below to see How to use IFERROR Excel function with some examples:

Here we provide a list of useful links which we think can be useful while trying to learn the IFERROR formula in Excel with some examples and tips.

Microsoft Office support page – Excel IFERROR function:
https://support.office.com/en-us/article/IFERROR-function-c526fd07-caeb-47b8-8bb6-63f3e417f611

## EXCEL FORMULAS TRAINER

As said: Practice Makes Perfect!

Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.

30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now: