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


workbook close vbaswot excel templateto find duplicate records in excelsecure excel spreadsheetexcel vba insert into access databaseconsolidate excel filesexcel insert pivot tablevba select sheetexcel dynamic chartsremove duplicate vbaexcel hide worksheetactivex control definitionexcel nested vlookupautofilter in vbaaccess vba query parametersexcel run macroexcel vba active workbookvba excel cellswhat is workbook and worksheethow to password protect excel file 2010ddl dml dcl commands in sql serverdashboard powerpoint templatems excel formulas with examplesexport xls to xmlexcel.worksheet.cellscolor in excel formulacase statement in excel formulaexcel pie chart examplesexcel macro programming tutorialhow do you create a macro in excel 2010sql and sas trainingcount if formula exceldatediff excelmsgbox yes no vbalookup in excelproject timelines in excelcapacity planning spreadsheet excelhow to use pivot table excel 2010convert an excel file to csvdownloadable schedule templatesimple macro in excelconsolidate data from multiple workbooksvba pathexample sumif excelhow to use macros in excel 2003fte analysis templatealphabetical order in excel 2007vba filter rangevisual basic excel macrovlookup argumentscombobox itemsvba clipboardmultiple if statements excel 2010unhide hidden workbookexcel schedule plannerformula for adding a column in excelexcel highlight duplicatespaste special formulaexcel assignments for beginnersmsgbox excelexcel userformsql recordsetwhat is countif function in excelhow do i unhide column ahow to protect excel worksheetvba drop down boxvba excel lookuphow to use sumif function in excelexcel vba scriptshow to learn formulas in excelexcel shortcut select rowms excel vlookup examplesexcel vba msgbox vbyesnoexcel line chart tutorialvisual basic codingsvba last row in rangeproject portfolio template excel