ISERRNA function
ISERRNA function
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
See also
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.
Syntax
ISERRNA(cellreference) |
Example 1
Cell |
Formula |
Value returned |
Scratch.A1 |
="5 + 3" |
"8" |
Scratch.B1 |
=ISERRNA(Scratch.A1) |
FALSE |
Returns FALSE because the value returned is available.
Example 2
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!