N
Syntax:
N ( value )
Description: Converts value to a number or, if value is a reference to a single cell, converts the value of that cell to a number.
Arguments:
Name |
Type |
Description |
---|---|---|
value |
any |
Value to be converted. |
Return Type and Value: number or error – An integer that is the converted value of value, or, if value is a reference to a single cell, the converted value of that cell, as follows:
value |
Value Returned |
---|---|
number |
That number |
TRUE |
1 |
FALSE |
0 |
error value |
That error value |
Anything else (including array and text) |
0 |
example: