ISERR

Definition: ISERR is a function that returns TRUE if a value is any error value except #N/A.

Syntax: =ISERR(value)

Situation: This formula is appropriate when you need to check if a value is any error value except #N/A.

Example: If you want to check if cell A1 contains any error value except #N/A, the formula =ISERR(A1) will return TRUE if it contains any error value except #N/A.