MS Excel: N Function
In Excel, the N function converts a value to a number.
The syntax for the N function is:
N( value )
value is a value to convert to a number.
Note:
- If value is a number, the N function returns a number.
- If value is a date, the N function returns the date as a serial number.
- If value is TRUE, the N function will return 1.
- If value is FALSE, the N function will return 0.
- If value is an error, the error value is returned.
- For all other values, the N function will return 0.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=N(A1) would return 35 =N(A2) would return 0 =N(A3) would return 1 =N(A4) would return 0 =N(A5) would return #DIV/0!