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 *log _{e}number*. 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.