Excel Function : ISERROR

Download now!

Excel Function : ISERROR

Category

Information

Description

Returns TRUE if the value is any error value

Microsoft Excel Reference Page

https://support.office.com/en-us/article/ISERROR-function-0f2d7971-6019-40a0-a171-f2d869135665

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.