Select Page

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

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 ## 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.