# 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.