ISERROR Function (VisioShapeSheet)

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Example 1
Example 2

Returns TRUE if the value of cellreference is any error type; otherwise, it returns FALSE. The ISERROR function is used in formulas that refer to another cell.

ISERROR(cellreference)

Parameters

Name

Required/Optional

Data Type

Description

cellreference

Required

String

Reference to a cell.

Cell

Formula

Value returned

Scratch.A1

=NA( )

#N/A!

Scratch.B1

=ISERROR(Scratch.A1)

TRUE

Returns TRUE because the #N/A! error is recognized by the ISERROR function. You can use ISERR to find all types but the #N/A! error.

Cell

Formula

Value returned

Scratch.X1

="House"

#VALUE!

Scratch.B1

=ISERROR(Scratch.X1)

TRUE

Returns TRUE because the #VALUE! error is recognized by the ISERROR function. To build an expression based on the #VALUE! error, use the ISERRVALUE function.

Show: