ISERR Function in Google Sheets

Determine if a value is an error, excluding the

ISERR Function

The ISERR function in Google Sheets is used to check if a value is an error, excluding the #N/A error.

Syntax

ISERR(value)
  • value: The value or expression you want to test. This is a required parameter.

Example

  1. Basic Error Check

Check if a value returns an error, excluding #N/A:

=ISERR(1/0)

This will return TRUE because dividing by zero results in an error.

Notes

  • The function returns TRUE for all errors except for #N/A.
  • Useful in conjunction with error handling functions like IFERROR.
  • ISERROR: Check if a value is any error, including #N/A.
  • IFERROR: Return a custom result if an error is found.