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



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)


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 show duplicate valuesenable developer tab in excel 2010insert a checkbox in excelexcel vba find lookinsubstitute function vbahow to use nested if statements in excelunlock protected excel sheetcombine multiple worksheets into oneunprotect sheet exceldaily log template excelmicrosoft excel test for interviewformula to remove special characters in exceldefinition of charts in excelexcel if blank cellcopy a worksheet in excelproject status report dashboard templatehow to do pivot tables in excel 2013simple macro program in excelcombine multiple excel worksheets into onevba macro buttondml and ddl commandsdelete duplicate data in excelexcel 3d chartcreate excel userformexcel count duplicateactivecell.selecthow to insert option button in excelddl and dml commands in sqlmacro excel for loopconverting excel to xmlvlookup reversevba excel copy pastestacked bar chart excel 2007pivot a table in excelexcel highlight duplicatebutton excel vbaadvance excel tipsaptitude and technical test questions and answersexcel worksheet tabsvba guihow to add entire column in exceldelete blanks in excelprotecting a worksheettrim function exampleddl dml dcl tcl commands sql serveroutlook attachment vbavlookup with conditionvba excel tutorialsunprotect vba projectresource calendar template excelconditional logic excelexcel template schedule plannersql interview questions in pdfvb recordsetmicrosoft excel find duplicateshow to dedupe in excel 2010what does sub mean in vbavba advancedunlock spreadsheet without passwordhow to add extra rows in excelvba sampleshlookup formula with exampleexcel password lockexcel mysql connectionexcel highlight duplicatesmacro tutorial in excelstep vbahow to add pivot table in excelexcel 2010 pivot table tutorialsort sql statementcalculate vba excelcoding vbavba save excelexcel match function examplehow do i unlock an excel spreadsheetexcel vba current sheetmerge text files in excelvb msgbox examplepassword protected excel sheet