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


concatenate excellexcel project trackerunprotect excel sheet 2013msg vbaexcel vba checkbox checkedvisual basic excel 2007 tutorial pdfwhat is a userform in excelexcel formula matchvba columnsexcel vba connect to access databasestacked bar graph excel 2010excel 2010 chart titlevba macros tutorialsexample sumif excelremove excel duplicatesdynamic charts in excelhide column excelhow to hide columns in excelvba copy row from one sheet to anothervlookup col_index_numvlookup with sumvba statusbarinsert in excel formulaexcel macro applicationsql basics commandsconvert excel rows to columnsiserror in excelexcel select duplicatesinsert drop down in excel 2007unlock excel filesshort key to insert row in excelwriting if statements in exceldynamic charts excelhow to protect excel sheet from deletingexcel vba formatexcel shortcut tipsvba excel copy worksheet to another workbookdashboard samples in excelmicrosoft excel advanced filterexcel consolidate functionvba character codesvlookup in ms excel 2007macros excel tutorialstatus update template powerpointunhide excel 2010vba access msgboxchange date format in teradatainserting a column in excelclick button vbaexcel construction estimating templateabout macros in excelhlookup in excel 2010 with examplepassword protect excel macroexcel developer tab 2007error in vbaexcel vba print commandforgotten password in excel to unprotect sheetpowerpoint dashboard examplesvbyesno in vbavba concatenationunlock vba codeexcel countif functionvba performancecharting in excelvba programming for beginnershlookup formula in excel with examplehow to increase column width in exceldelete rows in excel using vbavba interview questionsexcel vba selected cellshow to append in excelhighlighting duplicates in excel 2010