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.
- All Excel versions
Excel LN Function Syntax
|number||A positive real number for which you want the natural logarithm.|
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:
- 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.
- Zero (0) or negative numbers will return a #NUM! error.