Home »
Excel-Built-In-Functions »
Excel-Information-Functions »
Excel-N-Function
The Excel N Function
Function Description
The Excel N function converts data into a numeric value, using the following rules:
- Numeric values remain the same;
- Dates are converted to serial numbers;
- The logical value TRUE is converted to the value 1;
- Error values return the same error;
- All other values (e.g. text or the logical value FALSE) are coverted to the value 0.
The syntax of the function is:
N( value )
where the value argument is the value (or a reference
to a cell containing the value) that is to be converted to a number.
Excel N Function Examples
Column B of the following spreadsheet shows examples of the Excel N function:
|
Formulas:
| |
A |
B |
| 1 |
|
=N( 10 ) |
| 2 |
|
=N( "10" ) |
| 3 |
01/01/2016 |
=N( A3 ) |
| 4 |
#N/A |
=N( A4 ) |
| 5 |
TRUE |
=N( A5 ) |
| 6 |
FALSE |
=N( A6 ) |
|
Results:
| |
A |
B |
C |
| 1 |
|
10 |
- The number 10 returns the value 10 |
| 2 |
|
0 |
- The text string "10" returns the value 0 |
| 3 |
01/01/2016 |
42370 |
- A date is returned as a date serial number |
| 4 |
#N/A |
#N/A |
- Any error returns the same error |
| 5 |
TRUE |
1 |
- The logical value TRUE returns the value 1 |
| 6 |
FALSE |
0 |
- The logical value FALSE returns the value 0 |
|
For further details of the Excel N function, see the
Microsoft Office website.