LN

Excel Functions

Get the natural logarithm of a number

Syntax

EXCEL

=LN(number)

Arguments

Parameter	Description
`number`	A number to take the natural logarithm of.

Return Value

The natural logarithm

Details

The LN function returns the natural logarithm of a given number. The natural logarithm is equivalent to log base e of a number, where e is Euler's number, a mathematical constant with the approximate value 2.71828182845904. The LN function is the inverse of the EXP function and is used to model exponential decay. The LN function takes just one argument, number, which should be a positive number. The equivalent form of the natural logarithm function is given by: Below is a graph of the natural log logarithm: The natural logarithm function and exponential function are the inverse of each other, as you can see in the graph below:

Examples

EXCEL

=LN(1) // returns 0
=LN(e) // returns 1
=LN(e^2) // returns 2

Examples

The equivalent form of the natural logarithm function is given by:

EXCEL

=LN(number)=LOG(number,e) // Where e ≈ 2.7128 or EXP(1)

Graphs

This inverse relationship can be represented with the formulas below, where the input to the LN function is the output of the EXP function:

EXCEL

= LN(EXP(1)) // returns 1
= LN(EXP(2)) // returns 2
= LN(EXP(n)) // returns n

LN

Syntax

Arguments

Return Value

Details

Examples

See Also