ISERROR Function - Returns True if any value is an error in Excel

This article introduces you to the ISERROR function – one of the functions in the information group widely used in Excel.

Description: Returns True if any value is an error in Excel.

Syntax: ISERROR(value)

Specifically:

- value: The value to determine errors, a mandatory parameter.

Note:

- The function returns True if the reference value points to any error value and vice versa if the value is not an error the function returns False.

For example:

Determine whether the values in value are error values or not?

- In the cell where calculation is needed enter the formula: =ISERROR(C6)

- Press Enter -> the returned value is:

- Similarly, copy the formula for the remaining values to get the result:

- In case value is not an error value -> the function returns False:

Above are the instructions and some specific examples of using the ISERROR function in Excel.

Wishing you success!