This documentation is archived and is not being maintained.
ISERRNA Function
Last modified: March 09, 2015
Applies to: Office 2013 | Visio 2013
In this article
Syntax
Example 1
Example 2
Returns TRUE if the value of cellreference is error type #N/A! (not available); otherwise, it returns FALSE. The ISERRNA function is used in formulas that refer to another cell.
ISERRNA(cellreference )
Parameters
Name
Required/Optional
Data Type
Description
cellreference
Required
String
Reference to a cell.
Cell
Formula
Value returned
Scratch.A1
="5 + 3"
"8"
Scratch.B1
=ISERRNA(Scratch.A1)
FALSE
Returns FALSE because the value returned is available.
Cell
Formula
Value returned
Scratch.A1
=NA( )
#N/A!
Scratch.B1
=ISERRNA(Scratch.A1)
TRUE
Returns TRUE because the value returned is error type #N/A!