Search

Excel has a dedicated function to calculate the natural logarithm of a number – LN Function.

While not as common, this is a useful function for many Excel users working with scientific, engineering, statistics, or financial data.

In this article, I will show you how to use the LN function to calculate the natural log value in Excel.

This Tutorial Covers:

## Excel LN Function – Syntax

Below is the syntax of the LN function in Excel:

`=LN(number)`

where the number is the argument where you provide the positive number for which you want to calculate the natural log value. This could also be a cell reference that contains the number.

The LN function can only take positive numbers as arguments. If you use a negative number within this function, it is going to give you the number error (#NUM!)

The natural logarithm is the logarithm to the base of the mathematical constant e (called Euler’s number with an approximate value of 2.71828).

In mathematics, the natural logarithm is the power to which e must be raised to obtain a given value. So when I calculate the natural log of 10 and the result is 2.302585, it means that I need to stack up the value of e 2.302585 times to reach 10

Now, let me show you an example of how to use the LN function.

Below, I have a data set where I have some numbers in column A, and I want to calculate their natural log value and get the result in column B:

The following formula would do this:

`=LN(A2)`

Enter this formula in cell B2, and then copy it for all the other cells in the column.

And if you have dynamic arrays in your Excel, you can also use the below formula:

`=LN(A2:A6)`

Here are a couple of interesting things to note:

• The natural log of the number 1 is 0 (as e raised to power 0 would give us 1)
• In cell A3, I have the value of E, which is 2.718281282. When I calculate the natural log for this number, it gives me 1. This is because e^1 is equal to 2.718281282.

Interesting Fact: The LN function in Excel is the inverse of the EXP function (EXP), which takes a number and gives us e raised to the power of that number. So if use =LN(EXP(10)), it would give me the result as 10. Another Similar function in Excel is the LOG function that returns the logarithm of a given number using the base you specify in the formula.

Another Similar function in Excel is the LOG function that returns the logarithm of a given number using the base you specify in the formula.

In this article, I showed you how to use the Excel LN function to calculate the natural log of values.

If you have any questions about the Excel LN function or if you have any suggestions for me, do let me know in the comments section.

Other Excel articles you may also like:

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster