N function
The N function is one of the information functions. It is used to convert a value to a number.
Syntax
N(value)
The N function has the following argument:
| Argument | Description |
|---|---|
| value | A value to test. |
The value argument can be one of the following:
| Value | Number |
|---|---|
| number | number |
| date | date as serial number |
| TRUE | 1 |
| FALSE | 0 |
| error | error value |
| Other | 0 |
Notes
How to apply the N function.
Examples
The figure below displays the result returned by the N function.
