Exceljet

Quick, clean, and to the point

Excel ISNA Function

Excel ISNA function
Summary 

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.

Purpose 
Test for the #N/A error
Return value 
A logical value (TRUE or FALSE)
Syntax 
=ISNA (value)
Arguments 
  • value - The value to check if #N/A.
Usage notes 

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:

=ISNA(A1) 

To explicitly force the #N/A error in a formula, you can use the NA function. The following will return true:

=ISNA(NA())

Notes:

  • 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.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.