The Excel N Function

Basic 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 (eg. 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 that is to be converted, and can be supplied as either a direct value, a reference to a cell, or as the result of another formula.


Excel N Function Examples

The following spreadsheet shows several examples of the Excel N function. The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas:
Example of use of the Excel N Function
 Results:
Excel N Function Results

Note that, in cells B3 of the above example spreadsheet, the date 01/01/2011 is converted to the serial number 40544. However, this serial number may differ on different computer systems.


Further information and examples of the Excel N function can be found on the Microsoft Office website.



Return to the Excel Information Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net