Home » Excel-Built-In-Functions » 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 format of the N 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.

Examples

The following spreadsheet shows several examples of the Excel N function. The format of the function is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right.

Note that, in cells B3 of the above example spreadsheet, the date 01/01/2010 is converted to the serial number 40179. However, this serial number may be different on different systems.