N Function

The N function is one of the information functions. It is used to convert a value to a number.

Syntax

N(value)

The N function has the following argument:

Argument Description
value A value to test.

The value argument can be one of the following:

Value Number
number number
date date as serial number
TRUE 1
FALSE 0
error error value
Other 0

Notes

How to apply the N function.

Examples

The figure below displays the result returned by the N function.

N Function