Documentation/Calc Functions/N

From The Document Foundation Wiki
Jump to navigation Jump to search



Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

N

Category:

Information

Summary:

Returns the numeric value of the given parameter.

Syntax:

N(Value)

Returns:

Returns 0 if parameter is text, FALSE or an empty cell.

If an error occurs the function returns the error value.

Arguments:

Value is the parameter to be converted into a number. N() returns the numeric value if it can. It returns the logical values TRUE and FALSE as 1 and 0 respectively. It returns text and an empty cell as 0.

Additional details:

Examples:

=N(123) returns 123

=N(5%) returns 0.05

=N(TRUE()) returns 1

=N(FALSE()) returns 0

=N("abc") returns 0

=N("123") returns 0

=N(A1) returns 0 where A1 is an empty cell

=N(1/0) returns #DIV/0!

=N(A1) returns 1.5 where A1 contains $1.50

=N(A1) returns 1500 where A1 contains 1.50E+03

=N(A1) returns 1.5 where A1 contains 1 1/2

=N(A1) returns 44291.44 where A1 contains the date and time 2021-04-05 10:30:00

=N(A1) returns 0 where A1 has the text format and contains 123

=N(A1) returns 0 where A1 contains '123

=N(NA()) returns #N/A

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: