ISNA Function in Excel: Syntax, Examples, and Tips

This article provides a clear overview of ISNA Function in Excel, with the main facts, useful context, and practical details organized for easy reading.

this guide will guide the syntax and usage of the ISNA () function in Excel.

Description

The ISNA () function helps you identify if the value is #N/A (the value is not available).

The ISNA () function returns TRUE if the cell contains #N/A values. Returns FALSE if the cell does not contain the value #N/A.

This function is often used in conjunction with VLOOKUP () and IF () functions.

Syntax

= ISNA (value)

With value as the value of the cell, the expression you need to check.

For Example

Simple example is as follows: You have cell B6 with a value of 35, cell B7 has the value #N/A, so when testing cell B6 and cell B7 with the ISNA function will have different results:

You can use the value as an expression, for example VLOOKUP expression as the example below:

Explain the above example:

1. The VLOOKUP () function did not find the value of L11 in the Price Code table, so the result is #N/A so the ISNA () function will return TRUE.

2. VLOOKUP () finds the value of L13 in the Price Code table so the result returned will be the value corresponding to the L13 code. So the ISNA () function will return the FALSE value because its value is different from #N/A.

In addition to combining with VLOOUP function, you can combine with IF function to get more complete results.