ISERROR Function (VisioShapeSheet)
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.