How To Use Excel ISNA Function

how to use excel isna function

Quick Intro

Use Excel ISNA Function if you want to test a value for #N/A error. In simple words, it will return TRUE if the cell or value you have specified has #N/A error, else it will return FALSE.

Syntax

ISNA(value)

  • value A cell reference or a value which you want to test.

More Information on Excel ISNA  Function

  • It will only consider #N/A, ignore other error values.
  • You can enter #N/A directly into the function.

Examples

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

As we know #N/A  means that that a value is not available. In the below example, I have used IF Function and VLOOKUP Function with ISNA to deliver a meaningful message to the user.

Use Excel ISNA Function With IF Function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel ISNA Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have ISERR function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.