Export (0) Print
Expand All
Expand Minimize

ISERRNA Function

Last modified: June 17, 2011

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Example 1
Example 2

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.

ISERRNA(cellreference)

Parameters

Name

Required/Optional

Data Type

Description

cellreference

Required

String

Reference to a cell.

Cell

Formula

Value returned

Scratch.A1

="5 + 3"

"8"

Scratch.B1

=ISERRNA(Scratch.A1)

FALSE

Returns FALSE because the value returned is available.

Cell

Formula

Value returned

Scratch.A1

=NA( )

#N/A!

Scratch.B1

=ISERRNA(Scratch.A1)

TRUE

Returns TRUE because the value returned is error type #N/A!

Show:
© 2014 Microsoft