|
<< Click to Display Table of Contents >> N (convert value into number) |
Syntax:
N(Value)
Description:
This converts a value into a number.
The specified value must be a number, a date value or a logical value, otherwise N returns zero.
Note:
This function was retained only for compatibility with older spreadsheet applications. It is no longer commonly used, as current spreadsheet applications (including PlanMaker) automatically convert values into numbers if necessary.
Example:
N("Text") returns 0
N("42") returns 0
N(42) returns 42
N(TRUE) returns 1
If cell A1 contains the date 09/25/2014, the following applies:
N(A1) returns 41907 (the serial number of that date)
See also: