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


excel project timeline templatelearn excel macrosexcel vba step by step tutorialopen dialog box vbaexcel countif functiontrim function in vbahow to use pivot in excel 2007copy worksheet to another workbooktop oop interview questionslearn macros in excelexcel formula to find duplicatesdata definition language commandsrows.count vbaexcel vba protect all sheetsexcel password protect workbookexcel sorting formulavlookup macro excelvlookup lock table arrayexcel combine data from multiple sheetsexcel macro programmingmacros in excel 2007vba filedialog filtershortcut key to delete sheet in excelddl dml dqlexcel numerical orderexcel offset columnvba arrayprotecting an excel spreadsheetdml commands sqldocmd.opentableexcel vba listboxopen excel file in vbaworking with macros in excel 2007vba array sortvba conditionexcel hyperlink to cellisna with vlookupsql query in excelformula for vlookup in excelvba do loopswhy does vlookup return 0excel function vlookupworkbooks.activateshortcut keys of ms excelaccess close form vbausing excel lookuphow to access vba in excel 2007vba comment codecommand button vbawhere is developer tab in excel 2013formula to find duplicates in excelvba merge cellsworkbooks.activateexcel vba conditional statementstutorial for macros in exceloutlook vba examplesexcel button hyperlinkexcel template for tracking tasksproject status dashboard templateremove duplicate values in excelwizard in excelexcel vba templatestemplate checklist excelhow to learn formulas in excelaccess vba inputboxunmerge all cellshow to title columns in excelhow to create project timeline in excelproject portfolio management template excelbeginners excel tutorialvba sort excelexcel vba rowsexcel shortcut deletehow to make tick boxes in excelexcel remove rowsexcel vba replace functionadd developer tab excel 2013excel 2007 unprotect workbookhow to put a password on a spreadsheet