N
Description
Returns a numeric value for the specified value, using these rules: dates are
converted to serial numbers, the logical value True is converted to the value 1,
numeric values remain the same, error values return the same error, and all other
values (such as text or the logical value True) are coverted to the value 0.
Syntax
N(
type_text
)
- type_text: The value to convert to a number.
Example
Formula | Result |
|---|---|
=N(A1) where A1 contains 12/31/2017 | 43100 |
=N(A1) where A1 contains 12-Dec-2017 13:55 PM | 0 |
=N(10) | 10 |