Check Sheet Logo
Check Sheet

ISNA

The ISNA function checks whether a value is #N/A. If the value is #N/A, the function returns TRUE; otherwise, it returns FALSE. This function is commonly used in combination with other functions that may return #N/A as a result.

Usage

Use the ISNA formula with the syntax shown below, it has 1 required parameter:

=ISNA(value)
Parameters:
  1. value (required):
    The value to be checked for #N/A.

Examples

Here are a few example use cases that explain how to use the ISNA formula in Google Sheets.

Checking for #N/A errors

The ISNA function can be used to check if a cell contains the #N/A error. This can be helpful when working with large datasets or complex formulas that may return errors.

Conditional formatting

The ISNA function can be used in combination with conditional formatting to highlight cells that contain #N/A errors. This can make it easier to identify and correct errors in a spreadsheet.

Error handling

The ISNA function can be used in combination with other functions to handle errors in a formula. For example, if a VLOOKUP function returns #N/A, you can use the IF function with ISNA to display a custom error message.

Common Mistakes

ISNA not working? Here are some common mistakes people make when using the ISNA Google Sheets Formula:

Not providing a value as input

The ISNA formula requires a value as input to determine whether it is #N/A or not. Make sure to provide a value as input.

Using the formula with non-numeric values

The ISNA formula only works with numeric values. If you try to use it with non-numeric values, it will return the #VALUE! error. Make sure to use it only with numeric values.

Not using parentheses around the input value

The ISNA formula requires the input value to be enclosed in parentheses. If you forget to do this, it will return the #NAME? error. Make sure to enclose the input value in parentheses.

Related Formulas

The following functions are similar to ISNA or are often used with it in a formula:

  • ISERROR

    The ISERROR formula is used to check if a value contains an error. This formula returns TRUE if the value is an error, and FALSE if it is not. This function is most commonly used in combination with other formulas that can return errors, to ensure that the resulting value is valid.

  • IFERROR

    The IFERROR formula is used to check whether a specified value results in an error or not. If the value results in an error, then it returns a user-specified value instead of the error. This function is commonly used to prevent errors from breaking a formula or to replace error messages with custom messages.

  • VLOOKUP

    The VLOOKUP function is a lookup formula used to search for a value in the first column of a range of cells (the search key) and return a value in the same row from a specified column in that range. This function is most commonly used to look up and retrieve data from a table.

  • HLOOKUP

    The HLOOKUP function is a lookup formula that searches for a key in the top row of a table and returns the value in the same column for a specified row. This function is commonly used to extract data from a table based on a specific criteria.

Learn More

You can learn more about the ISNA Google Sheets function on Google Support.