ISERRVALUE Function [Visio 2003 SDK Documentation]
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.
ISERRVALUE(cellreference)
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 Office 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 the Visio application to return the value of the original cell.