SpreadJS Documentation
N
SpreadJS Documentation > Formula Reference > Formula Functions > N

This function returns a value converted to a number.

Syntax

N(value)

Arguments

Use any value as the argument.

Remarks

It is not always necessary to use this function, because Spread automatically converts values as necessary in many cases.

Data Types

Accepts many types of data. Returns numeric data.

Examples

N(G12)

N(R12C7)

N(2.53) gives the result 2.53

N(TRUE) gives the result 1

See Also