Spread Formula Reference
LN
Formula Functions > Functions H to L > LN

This function returns the natural logarithm of the specified number.

Syntax

LN(value)

Arguments

For the argument, specify a positive numeric value.

Remarks

This function is the inverse of EXP, so LN(EXP(x)) is x.

Data Types

Accepts numeric data. Returns numeric data.

Examples

LN(B3)

LN(R1C2)

LN(10) gives the result 2.3025850930

LN(exp(1)) gives the result 1

Version Available

This function is available in product version 1.0 or later.

See Also

EXP | LOG | LOGINV | Math and Trigonometry Functions