N

The N function converts a value to a number.

Syntax

=N(value)

Parameters

• value: The value you want to convert to a number

Examples

=N(123) // Returns 123
=N(TRUE) // Returns 1
=N(FALSE) // Returns 0
=N("123") // Returns #VALUE! error