Exceljet

Quick, clean, and to the point

Excel N Function

Excel N function
Summary 

The Excel N function returns a number when given a value. The N function can be used to convert TRUE and FALSE to 1 and 0 respectively. When given a text value, the N function returns zero.

Purpose 
Convert a value to a number
Return value 
A number or error code
Syntax 
=N (value)
Arguments 
  • value - The value to convert to a number.
Usage notes 

Use the N function to convert value to a number. Values are converted according the the following table:

Input value Return value
Any number Same number
A recognized date A date in Excel serial number format
TRUE 1
FALSE 0
An error code (#VALUE, #N/A, etc) Same error code
Other values 0

In most cases, using the N function is unnecessary, because Excel automatically converts values when needed.

The N function is provided for compatibility with other spreadsheet programs.