| title | manager | ms.date | ms.audience | ms.topic | f1_keywords | ms.localizationpriority | ms.assetid | description | |
|---|---|---|---|---|---|---|---|---|---|
ISERRVALUE Function |
lindalu |
03/09/2015 |
Developer |
reference |
|
medium |
c7feec6f-f47a-60ee-b056-7b2dc51ed9a9 |
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. |
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 )
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| cellreference |
Required |
String |
Reference to a cell. |
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.
| 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.
| 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.