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 Log_e(x) ), is the logarithm to the base e.

Syntax of Natural Logarithmic Function in Excel – LN()

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

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

Result

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