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 any error type; otherwise, it returns FALSE. The ISERROR function is used in formulas that refer to another cell.
Syntax
ISERROR(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 |
=ISERROR(Scratch.A1) |
TRUE |
Returns TRUE because the #N/A! error is recognized by the ISERROR function. You can use ISERR to find all types but the #N/A! error.
Example 2
| Cell | Formula | Value returned |
|---|---|---|
| Scratch.X1 |
="House" |
#VALUE! |
| Scratch.B1 |
=ISERROR(Scratch.X1) |
TRUE |
Returns TRUE because the #VALUE! error is recognized by the ISERROR function. To build an expression based on the #VALUE! error, use the ISERRVALUE function.