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


excel vba application.waituse of sumifcopy excel sheet to another workbookexcel 2007 pivot chartmatch function excelpivot table wizard excel 2013excel 2013 pivot table calculated fieldrecordset vba exceldynamic chart in excelcase function in vbavariable sheet name in excel formuladelete multiple rows in excelhow to use pivot table in excel 2010 with examplehow to use if condition in excel 2007vba code libraryexcel auto sort dataexcel vba userformexcel graph sheetnested vlookup excelexcel macro hide columnsvba adodb connection referencestatic vbaexcel macro to open a filehow to find duplicates in excel 2003vlookup example 2010vlookup in macrodelete worksheet vbavba excel basicshow to add multiple rows in excelunprotect excel sheet passwordvba status barinsert checkbox in excel 2007excel formula to find duplicates in a listlearn excel macros step by stephow to use the vlookup functionvb example programsconvert excel to csv comma delimitedexcel formula sum ifvba define variableshortcut for insert row in excelpowerpoint vba tutorialvba tutorial advancedturn on autofilter excel 2010filefilter vbacountif function in excel 2007how to create xml file in excel 2007pivot table 2013 tutorialtypeof vbaexcel combobox valuessumif formulashow to delete a row in excel using vbavba to export access query to excelexcel vba screenupdatingvbscript parse text filesample project timelinesexample of lookup function in excelhighlight duplicate values in excelvba code tutorialvlookup excel example 2010excel forms tutorialsample macros in excelvba codes for accesshow to insert a row on excellock excel sheet for editingchart creation in excelexcel chart add onshow to highlight column in excelactiveworkbook.saveas filenamerun sub in vbaproject gantt chart xlsexcel delete duplicates in columnhow to title columns in excel