ISERROR Function in Excel

Home/Excel Formulas/ISERROR Function in Excel

What is the use of ISERROR function?

ISERROR Function in Excel tests if given value is an error or not(is considers #N/A as an error) and returns TRUE if it finds error;otherwise returns FALSE

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

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 ISERROR function?

ISERROR Function in Excel- Syntax

ISERROR( value)

value : value to be checked

ISERROR Function in Excel – Examples

ISERROR Function in Excel- Example 1

Example 1: Returns the FALSE as the given value is not an Error
Example 2: Returns the TRUE as the given value is an Error
Example 3: Returns the FALSE as the given value is not an Error
Example 4: Returns the TRUE as the given value is an Error (#NA is an Error)

Reference:

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

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

LIMITED TIME OFFER
By |March 18th, 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


run a macro in excel 2007vba save as csvvba drop down listdim fso as filesystemobjectexcel password workbookvlookup tutorial for beginnersexcel 2007 chart wizardlookup function in excel 2010vlookup explanationcolumn addition worksheetexcel macro creationexcel macros templatesexcel forms tutorialstacked column chart excel 2010vba application pathformula of vlookupexcel command buttonsvba password codemeaning of excel in hindisas sql exampleunprotect spreadsheetexcel vba delete selected rowsvba combobox listexcel macro free workbookexcel 2010 chart wizardfso file existsexcel ribbon menuhow does vlookup work in excel 2007software project timeline templateexcel duplicate sheetleft excel vbaexcel copy worksheetdeleting a pivot tableexcel formula for alphabetical orderword vba userformexcel macros how toeasy excel macrosexcel vba call macroexcel vba rangeexcel vba copy paste rangevba mergeweekly plan template excelchange vbaexcel vba protect workbookmerge worksheets excelexit loop vba excelchar excelestimate template word freeremove blank from pivot tablecreating a hyperlink in excelhow to delete a row in excel using vbaexcel vba adoshortcut key to delete a row in excelprotecting an excel spreadsheetremove excel duplicatessql ddl and dmlvba export excel to accesserase vbadatabase dmlbest excel dashboard templatesdelete columns in excelwhat does merge cells mean in excelwith activesheetfind duplicates excel 2010sql faqs with answers pdfsql server pivot table exampleexcel formula vbaformula sumif excelhow to hide and unhide columns in excel 2007recording macros in excel 2007excel hide cellexcel vba do while loopvlookup lock table arrayproject tracking spreadsheet templatefind duplicates in a columnplanner excel templatehow to use autofit in excel