Documentation/Calc Functions/LN
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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:
Where x is the Number
The figure below illustrates the 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:
ODF standard:
Equivalent Excel functions:
LN