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.