Returns the natural logarithm of a number.
Sintaxis
LN(number)Argumentos
numberobligatorio
The positive real number for which you want the natural logarithm.
The LN function calculates the logarithm of a number to the base e (the constant 2.71828182845904). It is the inverse function of the EXP function.
=LN(1)→0The natural logarithm of 1 is 0.
=LN(EXP(3))→3Since LN is the inverse of EXP, the result is the original exponent.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =LN(number) and replace 'number' with a positive value or a cell reference.
Press Enter
Press the Enter key to calculate the natural logarithm.
The function will return a #NUM! error because the natural logarithm is undefined for non-positive numbers.