Export (0) Print
Expand All
Expand Minimize

ISERRVALUE Function

Last modified: June 17, 2011

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2

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)

Parameters

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.

Show:
© 2014 Microsoft