N

Converts the specified value to number.

Syntax

N( Any x ) → Number

Parameters

x

Required. The value to convert.

Remarks

If x is a reference, the value of the referenced cell is examined. If the value is a number, it is returned as is. If the value is logical, the function returns 1 for TRUE and 0 for FALSE. If the value is time or date, the serial number of the value is returned. If x is text or #N/A, the function returns 0. If x is an error other than #N/A, the error is returned. In any other case, the function returns 0.

Example

Formula

=N(1>0)
=N("5")
=N(100)

See Also

Function Reference
T Function
VALUE Function