title | manager | ms.date | ms.audience | ms.topic | f1_keywords | ms.localizationpriority | ms.assetid | description | |
---|---|---|---|---|---|---|---|---|---|
ISERRNA Function |
lindalu |
03/09/2015 |
Developer |
reference |
|
medium |
6ee7dc3d-efe9-c862-f71d-034b3d9c3ec6 |
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. |
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 )
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!