Parameter List
Syntax
N(value)
value
The value to convert to a number. Can be a number, text, logical value, date, error, or cell reference. For example: "123"
, TRUE
, A1
, or DATE(2023,1,1)
.
More details
The N function is primarily used for compatibility with other spreadsheet applications and for converting values in array formulas. It returns 0 for TRUE, 1 for FALSE, serial numbers for dates, and 0 for text that cannot be converted to numbers. This function is particularly useful when you need to ensure a value is treated as a numeric type.