How to Use LN in Google Sheets in 2020?

LNReturns the the logarithm of a number, base e (Euler’s number).

Sample Usage

LN(100)

LN(A2)

Syntax

LN(value)

value – The value for which to calculate the logarithm, base e.

value must be positive.

Notes

LN is equivalent to LOG given base of e, or EXP(1).

See Also

SQRTPI: Returns the positive square root of the product of Pi and the given positive number.

SQRT: Returns the positive square root of a positive number.

POWER: Returns a number raised to a power.

LOG10: Returns the the logarithm of a number, base 10.

LOG: Returns the the logarithm of a number given a base.

GAMMALN: Returns the the logarithm of a specified Gamma function, base e (Euler’s number).

EXP: Returns Euler’s number, e (~2.718) raised to a power.

Examples