Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 )
Parameters
Name | Required/Optional | Data Type | Description |
---|---|---|---|
cellreference |
Required |
String |
Reference to a cell. |
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!