Documentation/How Tos/Calc: ISNA function
From Apache OpenOffice Wiki
<
Documentation
|
How Tos
Revision as of 12:33, 16 July 2018 by
Sancho
(
Talk
|
contribs
)
(
diff
)
← Older revision
|
Latest revision
(
diff
) |
Newer revision →
(
diff
)
Jump to:
navigation
,
search
CALC FUNCTIONS
Information Functions
FUNCTIONS
Cell
Current
Formula
Isblank
Iserr
Iserror
Iseven
Iseven Add
Islogical
Isna
Isnontext
Isnumber
Isodd
Isodd Add
Isref
Istext
N
Na
Type
< Previous Page
Next Page >
Contents
1
ISNA
1.1
Syntax:
1.2
Example:
ISNA
Tests for the
#N/A
(Not Available) error value.
Syntax:
ISNA(value)
Returns
TRUE
if
value
is or refers to the
#N/A
(Not Available) error and
FALSE
otherwise.
Example:
ISNA(NA())
returns
TRUE
, because
NA()
returns the
#N/A
error.
ISNA(1/0)
returns
FALSE
, because
1/0
is a
#DIV/0!
error, not a
#N/A
error.
ISNA(A1)
where A1 contains
"dog"
, returns
FALSE
, because
"dog"
is text, not an error.
See Also
ISERR
ISERROR
NA
Information functions
Functions listed alphabetically
Functions listed by category
Category
:
Documentation/Reference/Calc/Information functions
Views
Page
Discussion
View source
History
Personal tools
Log in
Navigation
Main Page
Recent changes
Download AOO
Documentation
User Forum
Extensions
Templates
Wiki Help
Print/export
Create a book
Download as PDF
Printable version
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information