Documentation/Calc Functions/N

Function name:
N

Category:
Information

Summary:
Converts the supplied argument to a number.

Syntax:
N(Value)

Returns:
The number returned depends on the nature of the argument as follows:


 * For a numeric argument, N returns that number.
 * For a Boolean argument, N returns 1 (TRUE) or 0 (FALSE).
 * For a date/time argument, N returns the equivalent date-time serial number.
 * For a string argument, or a reference to an empty cell, N returns the value 0.
 * For an argument that represents an error condition, N propagates the error code.

Arguments:
Value is an expression, or a reference to a cell containing that expression, that is to be converted to a number.

Additional details:
None

Related LibreOffice functions:
T

VALUE

ODF standard:
Section 6.13.26, part 2

Equivalent Excel functions:
N