Excel Function : ISERROR

Download now!

Excel Function : ISERROR




Returns TRUE if the value is any error value

Microsoft Excel Reference Page


Syntax and Description of the ISERROR Excel Function

The ISERROR function in Excel returns TRUE if the value is an error and FALSE if not. The syntax for the ISERROR function is as follows: =ISERROR(value) where "value" is the value to be checked for errors.

About ISERROR Excel Function

ISERROR returns TRUE if the value is an error value (#NULL!, #DIV/0!, #VALUE!, #REF!, #NAME?, #NUM!), and FALSE otherwise.