ISERRNA Function
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!