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

erase vbaexample of sumif in excelword userform examplesrange vba variablehide sheets in excel vbavba string to integerinsert worksheetvba byvalif functions excel 2013vbscript examples in notepadvba excel tutorialsvb6 directory existselseif excelif statement excel examplescells in a spreadsheetvba excel rangeunprotect excellvbscript in excelexcel activeworkbook saveasvba instr examplemacro delete rowshortcut keys for microsoft excelexcel vba & operatorexcell lookupcsv converter to excelvba delete columnexcel templates for construction project managementisblank function excelvba excel 2003excel macros password removerhlookup in excel 2010 with examplehow do you sort alphabetically in excelvba pdf to excelspss sqlvba excel remove duplicatesspss video tutorials for beginnersexcel checkboxesvba loop syntaxexcel 2010 pivot table tutorialbcg interview processmacro copy and pastehow to change column name in excelconstruction timeline template excelexcel scripting tutorialexcel look up functionhow to protect a excel workbookadvanced excel formulas with examples in excel sheetdynamic excel chartshow to create activex controlhow do you insert rows in excelvba call procedurecoding macros in excelvba introductionmacro excel tutorialexcel userform tutorial pdfextract url from hyperlink excelexcel formula matchcheckbox background colorblank checks worksheetexcel vba programmingvba uppercase functionms excel test questions and answershow to merge excel columnsmerging cells in excel 2013how do you remove duplicates in excelexcel 2007 hide columnsbasic macros in excelexcel sumif function examplemacro delete rowmerge and centre in excelexcel vba msgboxexcel vba cells valuevbscript msgbox examplesexcel 2010 remove duplicate rowsunprotect excellexcel 2010 chart titleformula vlookup excelswot analysis presentation templaterun sql in excel