Excel ISNA Function

HomeExcel FunctionsExcel ISNA Function (Example + Sample File)

What is EXCEL ISNA FUNCTION

The Excel ISNA Function is listed under Microsoft Excel's Information Functions category. It returns TRUE if the value supplied (or the value in the cell referred) is an #N/A error. In simple words, it only considers the #N/A and returns TRUE, and FALSE for everything else.

How to use it

To learn how to use the ISNA function in Excel, you need to understand its syntax and arguments:

Syntax

ISNA(value)

Arguments

  • value: The cell reference or a value that you want to test.

Notes

  • It will only consider #N/A, ignore other error values.

Example

To master the ISNA function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used ISNA to check different error values and we have got TRUE only in the case of #N/A error value

And in the below example, we have used IF and VLOOKUP with ISNA to deliver a meaningful message to the user.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.