Documentation/Calc Functions/LN

From The Document Foundation Wiki
Jump to: navigation, search
Other languages:
English

Function name:

LN

Category:

Mathematical

Summary:

Returns the natural logarithm based on the constant e of a number. The constant e has a value of approximately 2.71828182845904.

Syntax:

LN(Number)

Returns:

Returns a real number.

Arguments:

Number is the positive real number or reference to the cell containing that number whose natural logarithm is to be calculated.

If Number is negative or 0, then the function returns an error value.

Additional details:

The formula used to calculate LN function is:

Ln.png

Where x is the Number

The GIF below illustrates the LN function.

LN function

Examples:

Formula Description Returns
=LN(3) the natural logarithm of 3 1.09861228866811
=LN(EXP(321)) the natural logarithm of e raised to the power 321 is itself 321
=LN(-5) function returns an error value since one of the arguments is negative Err:502

Related LibreOffice functions:

LOG

LOG10

POWER

EXP

ODF standard:

Section 6.16.39, part2

Equivalent Excel functions:

LN