The ISNA function is used to test if a value is #N/A and can be used to prevent errors in other formulas.

ISNA takes 1 required argument and no optional arguments:

Syntax: ISNA(value)

#1)
Using the ISNA function:
#2)
The arguments for the ISNA function are:
Argument Required? Description
value Required The value that you want tested. Value can be a blank (empty) cell, error, logical expression, text, number, reference value, or a name referring to any of these, that you want to test.

Summary

The ISNA function is used to test if a value is #N/A and can be used to prevent errors in other formulas.
comments powered by Disqus