N function
From Apache OpenOffice Wiki
<
Documentation
|
How Tos
Revision as of 13:29, 31 January 2024 by
DiGro
(
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 >
N
Returns the numeric value.
Syntax:
N(value)
returns the numeric value of
value
if possible. It returns the logical values
TRUE
and
FALSE
as
1
and
0
respectively.
N()
is not intended to convert text to a number - use the
VALUE()
function instead.
Example:
N(123)
returns
123
, because
123
is (already) a number.
N(TRUE)
returns
1
.
N(A3)
where A3 contains
FALSE
, returns
0
.
See Also
ISNUMBER
VALUE
T
TEXT
FIXED
DECIMAL
Information functions
Functions listed alphabetically
Functions listed by category
Categories
:
Documentation/Reference/Calc
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
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information
In other languages
Nederlands