IFERROR Function in Excel

Home/Excel Formulas/IFERROR Function in Excel

What is the use of IFERROR function?

IFERROR Function in Excel check a value and it returns the value if there is no error or else it returns the specified value_if error



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

What is the syntax of IFERROR function?

IFERROR Function in Excel - Syntax

IFERROR( value, value_if_error )

value : value to be checked
value_if_error : value to be returned if the given value is error

IFERROR Function in Excel – Examples

IFERROR Function in Excel - Example 1

Example 1: Returns the actual value 2000 as it is not found any error
Example 2: Returns “error” asthe given value is an error
Example 3: Returns the actual value 4000 as it is not found any error
Example 4: Returns “error” asthe given value is an error


Please refer the below article for more Logical Excel functions.
Logical Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

By |March 4th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment

Related pages

copy paste macro excelexcel export to txtexcel vlookup function tutorialexcel hide columnfilter using vbadynamic dashboard in excelexcel dashboard templates xlsclearcontents vbascripting filesystemobject vbaexcel 2007 macroshow to unprotect excel sheet 2010 with passwordadvanced pivot table excel 2007vba programming for excelproject proposal template excelexcel vba backcolorvba excel workbook openvba lessonsunhide hidden columns in excelnew line in vbacells in vbaexamples of macros in excelvba commandsexcel macro print to pdfproject status dashboard templatevba selection autofilterlearning vlookup in excelprotecting a worksheetinserting lines in excelsql statement in vbamacros excel 2007excel pull data from another sheetmerge multiple excel files into one sheet vbaexcel macros advancedvba sheet cellslast cell in column vbasql excel table2500 excel vba examplesspss sqlexcel 3d pie chartexcel vba removevba fileopenvlookup two worksheetsinserting pivot table in excel 2010excel pivot chart tutorialexcel merge sheets by columnlearn macros in excelvlookup formulaspricing model template in excelexcel vba color indextable of contents worksheetsvisual basic commandsvba excel examples with codestextbox propertiesunhide personal xlsbdifference between two dates in excelplanning calendar template excelexcel vba close workbookmessage box excel vbaactivex vbavba load formcode vba exceladvanced excel pptsql question and answer pdfexcel macro variableshow to delete duplicate data in excelhide column in excelexcel vba create formvb6 option buttoncopy cells vbaremove excel macro passworddeveloper tab in excel 2010cell color function excel