N function
Summary
Returns a value converted to a number
Syntax
N(value)
The N function syntax has the following arguments:
• Value Required. The value you want converted. N converts values listed in the following table.
If value is or refers to | N returns
A number | That number
A date, in one of the built-in date formats available in Microsoft Excel | The serial number of that date
TRUE | 1
FALSE | 0
An error value, such as #DIV/0! | The error value
Anything else | 0
• Value Required. The value you want converted. N converts values listed in the following table.
If value is or refers to | N returns
A number | That number
A date, in one of the built-in date formats available in Microsoft Excel | The serial number of that date
TRUE | 1
FALSE | 0
An error value, such as #DIV/0! | The error value
Anything else | 0
Example
=N(A2)
=N(A3)
=N(A4)
=N(A5)
=N("7")
=N(A3)
=N(A4)
=N(A5)
=N("7")