Skip to main content

ISERR

Definition of ISERR

Checks whether a value is an error other than `#N/A`.

Sample Usage

ISERR(A2)

Syntax

ISERR(value)

  • value - The value to be verified as an error type other than #N/A.

    • ISERR returns TRUE if value is any error other than #N/A,including #DIV/0!#NAME?#NULL!#NUM!#VALUE!, and #REF!. This is useful in certain applications where #N/A may be a valid outcome, whereas the other error types always indicate a fundamental problem.

Notes

  • ISERR returns FALSE on #N/A, unlike ISERROR, which returns TRUE on all errors. Ensure that the correct call is used.

  • This function is most often used in conjunction with IF in conditional statements.

See Also

ISTEXT: Checks whether a value is text.

ISREF: Checks whether a value is a valid cell reference.

ISODD: Checks whether the provided value is odd.

ISNUMBER: Checks whether a value is a number.

ISNONTEXT: Checks whether a value is non-textual.

ISNA: Checks whether a value is the error `#N/A`.

ISLOGICAL: Checks whether a value is `TRUE` or `FALSE`.

ISEVEN: Checks whether the provided value is even.

ISERROR: Checks whether a value is an error.

ISBLANK: Checks whether the referenced cell is empty.

IF: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.

In order to use the ISERR formula, start with your edited Excellentable

 

Then type in the ISERR Formula in the area you would like to display the outcome:

 

Type in the complete ISERR formula for a cell as shown below:

 

Excellentable will generate the outcome when hitting enter.

 

Error.

User does not have sufficient privileges to access this Content
Learn More

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.