ISERR Function in Excel

Home/Excel Formulas/ISERR Function in Excel

What is the use of ISERR function?

ISERR Function in Excel tests if given value is an error or not(EXCEPT for the #N/A 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 ISERR function?

ISERR Function in Excel- Syntax

ISERR( value)

value value to be checked

ISERR Function in Excel – Examples

ISERR 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 FALSE as the given value is not an Error (#NA is not 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

 
 
Related Resource External VBA Reference
Excel VBA Reference Project Management Reference
VBA Reference:
Excel Reference:
By |March 15th, 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


unprotect excel 2010 workbook without passwordexcel vba interview questionsdynamic array vba excelvlookup and hlookup in excel 2010vba user inputwriting a macro in excelvba statusbarautomatically hide rows in excelfilesystemobject movefilevba activecell.rowexcel pivotingcapacity planning template xlshow to learn formulas in excelexcel vba borderaroundhyperlink formula in excel2 if statements in excelvba getopenfilenamesample excel dashboardexcel macros advancedexcel vba vlookup formulalookup function in excel 2007dynamic dashboard template in excelvba manualinterview questions for freshers pdfxls macro tutorialproject budget template excelexcel auto row heightexcel tutorials for beginnersexcel 2003 macrosexcel vba count rowsexcel vba check boxhorizontal lookup excelvba excel select workbookhow to build an excel macroeliminating duplicates in excelvba filter excelexcel developer toolbarfree excel dashboard widgetsworking with arrays in excel vbavba userform templateshow to do hlookup in excelhow to write a vlookup formula in excelhow to insert comment in excelhow to use a pivot table excel 2010how to setup a macro in excelexcel vba for each cell in rangecreating a dashboard in excelpivot table refresh allhow do you sort columns in excelsql interview questions and answers for business analystexcel vba userform combobox additemtimevalue vbasql recordsetvlookup left to rightvlookup excel sampleactiveworkbookhow to merge excel cellsmicrosoft excel create chartproject plan template microsoft wordlookup function excel 2007excel vba clear rangeexcel macro dimremove duplicate rows in excelcreate vbaexcel chart wizardrange activecellexcel vba remove rowexcel macro tipsunprotect an excel workbook without passwordexcel vba selectionvba text boxexcel vba active worksheetproject tracking with excelwriting an excel macrohighlight duplicates