LN Function in Excel calculates the natural logarithm of a given number.
The Natural Logarithm of a number, ( Ln(x) or Loge(x) ), is the logarithm to the base e.
Syntax of Natural Logarithmic Function in Excel – LN()
LN(number)
Where Argument number is the positive real number that you want to calculate the natural logarithm of.
Example of Natural Logarithmic Function in Excel – LN()
Formula
e0 = 1, therefore LN(1)=0 so the result will be
Result
#NUM! Error occurs if the supplied number argument is negative or zero.