ISERR Function [Visio 2003 SDK Documentation]
Returns TRUE if the value of cellreference is any error type except #N/A; otherwise, it returns FALSE. The ISERR function is used in formulas that refer to another cell.
ISERR(cellreference)
Example 1
Cell | Formula | Value returned |
---|---|---|
Scratch.A1 | =NA( ) | #N/A! |
Scratch.B1 | =ISERR(Scratch.A1) | FALSE |
Returns FALSE because the #N/A! error is not recognized by the ISERR function. Use ISERROR to find all error types.
Example 2
Cell | Formula | Value returned |
---|---|---|
Scratch.X1 | ="House" | #VALUE! |
Scratch.A1 | =ISERR(Scratch.X1) | TRUE |
Returns TRUE because the #VALUE! error is recognized by the ISERR function.