The Excel LN function is a Math formula that returns the natural logarithm of a given number. The natural logarithm of a number is the power to which e would have to be raised to find that number. Natural logarithms are based on the constant e which is approximately 2.71828.In this guide, we’re going to show you how to use the Excel LN function and also go over some tips and error handling methods.


Supported versions

  • All Excel versions

Excel LN Function Syntax

LN(number)


Arguments

number A positive real number for which you want the natural logarithm.

Example

The LN function calculates the natural logarithm of the number entered as the argument. The equivalent math formula for this operation is logenumber. According to this definition, =LOG(number, EXP(1)) equals LN(number). Here is a sample use:

=LN(3) returns the natural logarithm of 3

Download Workbook


Tips

  • The constant e is called Euler’s number, named after the Swiss mathematician Leonhard Euler.
  • EXP is the inverse of LN, the formula that calculates the natural logarithm of a number.
    =number=LN(EXP(number))
    =LN(EXP(1)) returns 1
  • You can use LOG function to find the logarithm of a given number.

Issues

  • Zero (0) or negative numbers will return a #NUM! error.