Documentation/Calc Functions/N

From The Document Foundation Wiki
Jump to: navigation, 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 or FALSE.

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 as 0.

Additional details:

Examples:

=N(123) returns 123

=N(TRUE()) returns 1

=N(FALSE()) returns 0

=N("abc") returns 0

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

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: