Definition of N
Returns the argument provided as a number.
value- The argument to be converted to a number.
valueis a number, the number is returned.
valueis a date or time,
Nreturns 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.
FALSEor any value not listed above,
Non numeric values in other cells, formatting (into currencies, scientific notation, etc.) is lost. To specify formatting on the return value of
N, 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.
TO_DATE: Converts a provided number to a date.
T: Returns string arguments as text.
In order to use the N formula, start with your edited Excellentable
Then type in the N Formula in the area you would like to display the outcome:
Type in the complete N formula for a cell as shown below:
Excellentable will generate the outcome when hitting enter.