ISERRVALUE function
ISERRVALUE function
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
See also
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) |
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 the Visio application to return the value of the original cell.