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 error type #VALUE, where an argument in the formula is the wrong type. The ISERRVALUE function is used in logical expressions that refer to another cell.
Syntax
ISERRVALUE(cellreference )
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| cellreference |
Required |
String |
Reference to a cell. |
Remarks
Scratch cells A through D won't return a #VALUE! error because the formula can contain numbers and letters in the same string. Cells X and Y must contain numbers only.
Example 1
| Cell | Formula | Value returned |
|---|---|---|
| Scratch.X1 |
= "House" |
#VALUE! |
| Scratch.A1 |
= If (ISERRVALUE(Scratch.X1),2,Scratch.X1) |
2 |
Returns 2 because the value returned is a #VALUE! error, and the expression instructs Microsoft Visio to return a 2 in place of the error.
Example 2
| Cell | Formula | Value returned |
|---|---|---|
| Scratch.A1 |
="5 + 7" |
5 + 7 |
| Scratch.B1 |
=If (ISERRVALUE(Scratch.A1),2,Scratch.A1) |
5 + 7 |
Returns 12 because the value returned is not a #VALUE! error, and the expression instructs Visio to return the value of the original cell.