LN Function in Excel – Calculate Natural logarithm in Excel

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

LN Function in Excel 1

e0 = 1, therefore LN(1)=0  so the result will be

Result

LN Function in Excel 2

#NUM! Error occurs if the supplied number argument is negative or zero.

previous LN Function in Excel                                                                                                                next LN Function in Excel