Documentation/Calc Functions/LN

From The Document Foundation Wiki
Jump to navigation Jump to search
This page contains changes which are not marked for translation.
Other languages:
English • ‎dansk



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 figure 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