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:

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.

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.