N

Converts a value to a number. If the value is already a number or can be converted to a number, it returns that number. For non-numeric values like text, logical values, or errors, it returns 0

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.

Examples

N("123") returns 123, converting text "123" to number 123.

N

Parameter List

Examples

Example 1

Example 2

Example 3

Example 4

Example 5

Example 6

Example 7

Example 8