|
<< Click to Display Table of Contents >> N (convert value into number) |
Syntax:
N(Value)
Description:
Converts a value to 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, where necessary.
Example:
N("Text") returns 0
N("42") returns 0
N(42) returns 42
N(TRUE) returns 1
If A1 contains the date 09/25/2014, the following applies:
N(A1) returns 41907 (the serial number of that date)
See also: