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

monthly one on one meeting templatehow to unhide column a in excel 2007protect formulas in excelunhide workbookunload me vba excelexcel vba combo boxexcel remove checkboxdelete row in excel vbapivot table option in excel 2010vba programming tutorial pdfisblank function in excelpivot table tutorial 2013microsoft excel coding tutorialexcel exam questions and answershow to use a pivot table in excel 2007excel unhide all sheetsinstr function in excelexcel vba columnsvba row countexcel vba userform examplesremove duplicates excel vbavbokonlyexcel activeworkbookopen xlsx in excel 2003unprotect excel forgot passwordcommand button vba excelexcel sheet cellsvba ebookvba form controlsexcel vba comboboxexcel trim formulaconvert csv file to excel 2010how to create a data entry form in excel 2007instr vba functionhighlight duplicate values in excelmerge cells in excel 2013working with graphs in exceldelete row in excel vbawebsite project plan template exceltypes of column chartsvba get file extensionadd developer tab to ribbon word 2007autofilter field vbaexcel combine data from multiple sheetshow to protect cells in a worksheetopen xlsx file with excel 2003vba checkbox checkedexcel 2007 find duplicatesexcel sql server querycombine multiple worksheets into one workbookvba create databaseexcel fix rowsadvanced pivot table techniquesuseful excel macroexcel macro sheetsmacro excel vbaexcel remove duplicate recordsexcel vlookup worksheetvba code to read excel filearray length in vbamicrosoft excel substituteadvanced excel tutorial pdf 2010debug print vbavba active workbookexcel hyperlink buttonunhide columns excelpowerpivot excel 2010 tutorialvba cell formulavba drop downexcel project management templatesimple excel macro exampledata analytics interview questions and answershow to break excel vba passwordexcel 2010 password protectexcel formula from another sheet