Excel ISNA Function
The Excel ISNA function returns TRUE when a cell contains the #N/A error and FALSE for any other value, or any other error type. You can use the ISNA function with the IF function test for an error and display a friendly message when it appears.
- value - The value to check if #N/A.
Use the ISNA function to check to check for #N/A errors. Normally, value is supplied as a cell reference. For example, if A1 contains #N/A, the following formula will return TRUE:
To explicitly force the #N/A error in a formula, you can use the NA function. The following will return true:
- ISNA is part of a group of functions called the "IS functions", which are often used to test the result of formulas for errors.
- With Excel 2007+, the IFERROR function can provide simpler, less redundant error checking.
- With Excel 2013+, the IFNA function can trap and handle #N/A errors specifically.