OpenOffice3.org Calc 3. Information Functions
N(value) Function
Returns the numeric value corresponding to
the argument “value”. The data to convert must be a valid numeric format. If the
argument is of type text, the function returns 0. If the argument is the logical
value FALSE, the function returns 0. If the argument contains a diferent error
value #N/A, the function returns the same error value. If the argument contains
the logical value TRUE, the function returns 1. The argument “value” contains
the reference to a cell that contains the data to evaluate, may also be a data
or an expression. For example:
=N(3433) Returns the number 3433.
=N("tres") Returns 0. The data is a text.
=N(6+33) Returns 39. Calculates the sum and returns the result.