ISNA

Excel Functions

Test for the #N/A error

Syntax

EXCEL

=ISNA(value)

Arguments

Parameter	Description
`value`	The value to check if #N/A.

Return Value

A logical value (TRUE or FALSE)

Details

The ISNA function returns TRUE when a cell contains the #N/A error and FALSE for any other value, or any other error type. The ISNA function takes one argument, value, which is typically a cell reference. If A1 contains the #N/A error, ISNA returns TRUE: ISNA returns FALSE for other values and errors: You can use the ISNA function with the IF function test for #N/A and display a friendly message if the error occurs. For example, to display a message if A1 contains #N/A and the value of A1 if not: The IFNA function is a more efficient way to trap the #N/A error. See VLOOKUP without NA error for an example.

Examples

If A1 contains the #N/A error, ISNA returns TRUE:

EXCEL

=ISNA(A1) // returns TRUE

Examples

ISNA returns FALSE for other values and errors:

EXCEL

=ISNA(100) // returns FALSE
=ISNA(5/0) // returns FALSE

Examples

You can use the ISNA function with the IF function test for #N/A and display a friendly message if the error occurs. For example, to display a message

EXCEL

=IF(ISNA(A1),"message",A1)

Return #N/A

To explicitly return the #N/A error in a formula, you can use the NA function:

EXCEL

=NA() // returns #N/A error

Return #N/A

The following will return true:

EXCEL

=ISNA(NA()) // returns TRUE

Count #N/A errors

To count cells in a range that contain #N/A errors, you can use the SUMPRODUCT function like this:

EXCEL

=SUMPRODUCT(--ISNA(range))

ISNA

Syntax

Arguments

Return Value

Details

Examples

See Also