Using the Excel N Function

Summary
The Excel N function converts a value to a number. For example, the function will convert TRUE to 1 and FALSE to zero (0).Syntax
=N (value)Syntax Breakdown
ValueRequired. The value that should be converted to a number.
The following table shows how N converts different values:
Value is or refers to | N returns |
---|---|
Number | That number |
A date in an Excel date format | Serial number of the date |
TRUE | 1 |
FALSE | Zero (0) |
Error value (#N/A, #REF!, etc.) | The error value |
Any other value | Zero (0) |