Returns the argument provided as a number.
Sample Usage
N(A2)
N(4)
Syntax
N(value)
-
value
- The argument to be converted to a number.-
If
value
isTRUE
,N
returns1
. -
If
value
is a number, the number is returned. -
If
value
is a date or time,N
returns a generated serial number, based on the number of days since December 30, 1899.- Negative values are interpreted as days before this date, and fractional values indicate time of day past midnight.
-
If
value
isFALSE
or any value not listed above,N
returns0
.
-
Notes
-
When using
N
on numeric values in other cells, formatting (into currencies, scientific notation, etc.) is lost. To specify formatting on the return value ofN
, simply apply the format desired to the cell containing the formula. -
This function is, in fact, rarely necessary as Google Spreadsheet automatically converts between most formats appropriately. It is provided primarily for compatibility with formulas used in other spreadsheet packages.
See Also
TO_DATE
: Converts a provided number to a date.
T
: Returns string arguments as text.