ISERR Function
Returns TRUE if the value of cellreference is any error type except #N/A; otherwise, it returns FALSE. The ISERR function is used in formulas that refer to another cell.
Syntax
ISERR(cellreference )
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| cellreference |
Required |
String |
Reference to a cell. |
Example 1
| Cell | Formula | Value returned |
|---|---|---|
| Scratch.A1 |
=NA( ) |
#N/A! |
| Scratch.B1 |
=ISERR(Scratch.A1) |
FALSE |
Returns FALSE because the #N/A! error is not recognized by the ISERR function. Use ISERROR to find all error types.
Example 2
| Cell | Formula | Value returned |
|---|---|---|
| Scratch.X1 |
="House" |
#VALUE! |
| Scratch.A1 |
=ISERR(Scratch.X1) |
TRUE |
Returns TRUE because the #VALUE! error is recognized by the ISERR function.