Returns the natural logarithm based on the constant e of a number. The constant e has a value of approximately 2.71828182845904.
Returns a real number.
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.
The formula used to calculate LN function is:
Where x is the Number
The figure below illustrates the LN function.
|=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:
Equivalent Excel functions: