ISERROR Function in Google Sheets

Determine if a value is an error, including the

ISERROR Function

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

Syntax

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

Example

  1. General Error Check

Check if a value returns any error, including #N/A:

=ISERROR(VLOOKUP("A", A2:B10, 2, FALSE))

This will return TRUE if the VLOOKUP fails.

Notes

  • The function returns TRUE for any error, including #N/A.
  • Commonly used for error handling in formulas.
  • ISERR: Check if a value is an error, excluding #N/A.
  • IFERROR: Handle errors by providing a custom result.