Main page /  Useful info about ShapeSheet™  / Visio ShapeSheet reference / ShapeSheet™. List of functions by category

ShapeSheet. Category Error Utilities

Note

This table contain functions which included in table for similar category in the book MS Visio 2003 Developer’s Survival Pack by Graham Wideman (see chapter 37) and also functions added in later versions.

The version information in which the function was added is taken from John's Goldsmith article Visio ShapeSheet Functions by Version

Name

Details

IFERROR

Version Added: 2010

Returns the evaluated result of a primary expression, if it does not evaluate to an error. Otherwise, returns the evaluated result of an alternate expression.

Syntax

IFERROR(primary expression, alternate expression)

Read more about function IFERROR

ISERR

Version Added: Pre 2003

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.

Syntax

ISERR(cellreference)

Read more about function ISERR

ISERRNA

Version Added: Pre 2003

Returns TRUE if the value of cellreference is error type #N/A! (not available); otherwise, it returns FALSE. The ISERRNA function is used in formulas that refer to another cell.

Syntax

ISERRNA(cellreference)

Read more about function ISERRNA

ISERROR

Version Added: Pre 2003

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.

Syntax

ISERROR(cellreference)

Read more about function ISERROR

ISERRVALUE

Version Added: Pre 2003

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)

Read more about function ISERRVALUE

NA

Version Added: Pre 2003

Use the NA function in a ShapeSheet cell where information is missing, so that the cell's default value is not used in calculations.

Syntax

NA( )

Read more about function NA

REF

Version Added: Pre 2003

The REF function returns the error value #REF!.

Syntax

REF( )

Read more about function REF