The ISERROR function is a versatile one that is very useful in testing an outcome of a formula so that you can account for any errors, more on that later…First, lets learn the syntax:


A1 is the cell you want to test for an error. If A1 contains #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME!, or #NULL!, the result will be TRUE, otherwise it will be FALSE.

The most common usefor this function is within the IF function to check for error and then handle it. For example:

if(iserror(A1), B1,A1)

The formula above checks A1 for an error, if there is an error it takes the value in B1, otherwise it will use the value in A1. This is also useful within the vlookup function since non matched values will return an error.

Joseph Harris
Excel Help

Related posts:

  1. Removing #N/A error in Excel using ISNA() The #N/A error happens most often when a lookup function...
  2. #VALUE! Error in Microsoft Excel The #VALUE error is an error that is seen almost...
  3. Vlookup – My Favorite Function Vlookup...
  4. Multiple Condition Vlookup Function Add-in – Excel The question we are asked most often by ExcelYogi readers...
  5. #DIV/0! Division by Zero Error in Excel The #DIV/0! error happens when the denominator (the number on...

This entry was posted on Sunday, April 3rd, 2011 at 5:36 pm and is filed under Excel Quick Tricks, Functions. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.