ISNA
TheISNA
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.
 How to use
ISNA
formula?  Examples of using
ISNA
formula ISNA
formula not working? Similar formulas to
ISNA
Usage
Use the ISNA
formula with the syntax shown below, it has 1 required parameter:
 value (required):
The value to be checked for #N/A.
Examples
Here are a few example use cases that explain how to use theISNA
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 nonnumeric values
The ISNA formula only works with numeric values. If you try to use it with nonnumeric 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 returnsTRUE
if the value is an error, andFALSE
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 userspecified 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.