How to Calculate Natural Logarithm in Excel (With 4 Examples)

For various numeric calculations, we need to find the natural logarithm of numbers. In this article, I will show you 4 practical examples to calculate natural logarithm in Excel.


Download Practice Workbook

Here, you can download and practice from our practice workbook for free.


What Is Natural Logarithm?

A natural logarithm is the logarithm of a number to the base of e. e is a constant number which is approximately 2.7128. It is a transcendental and irrational number. It is normally expressed as lnx or loge x. Keep in mind, that you can find a natural logarithm of positive numbers only.


Introduction to the LN Function

The LN functionΒ is an Excel function that returns the natural logarithm of a number in Excel. It has mainly one argument only. That is- number. So, if you put a number inside the LN function, it would give you the natural logarithm of that number. But, remember, do not put zero or negative numbers in the argument. This will show you the #NUM! error. Moreover, do not put a non-numeric value in the argument of the function. It will show the #VALUE! error.

Introduction to the LN Function

Read More: How to Calculate Log in Excel (6 Effective Methods)


4 Useful Examples to Calculate Natural Logarithm in Excel

Here, we have 4 types of numbers in our dataset. Each type is tried and explained in an individual sheet.

Calculate Natural Logarithm in Excel

Go through the 4 useful applications of calculating the natural logarithm in Excel below. πŸ‘‡


1. Calculate Natural Logarithm of a Positive Integer Number

If you want to calculate the natural logarithm of a positive integer number in Excel, go through the steps below. πŸ‘‡

πŸ“Œ Steps:

  • First, click on the cell where you want to put the natural logarithm result.
  • Subsequently, put an equal sign (=) and write LN. As a result, the LN function will be active. Now, refer to the B5 cell as you want to find the natural logarithm of this cell. So, the formula will look like this.
=LN(B5)

Use the LN Function to Calculate the Natural Logarithm of a Positive Integer

  • Next, place your cursor at the bottom right corner of the result cell. Now, drag the fill handle below to copy the formula to all the cells below.

Copy the LN Formula

Thus, you can find the natural logarithm of all the positive integers. And, the result looks like this. πŸ‘‡

Natural Logarithm of all Positive Integers

Read More: How to Log Transform Data in Excel (4 Easy Methods)


2. Calculate Natural Logarithm of a Fractional Number

Besides, you can also find the natural logarithm of fraction numbers. Go through the steps below to accomplish this. πŸ‘‡

πŸ“Œ Steps:

  • First, click on the cell where you want to put the natural logarithm result.
  • Subsequently, put an equal sign (=) and write LN. As a result, the LN function will be active. Now, refer to the B5 cell as you want to find the natural logarithm of this cell. So, the formula will look like this.
=LN(B5)

Use the LN Function to Calculate Natural Logarithm of Fractional Numbers

  • Next, place your cursor at the bottom right corner of the result cell. Now, drag the fill handle below to copy the formula to all the cells below.

Copy the LN Formula

Thus, you can find the natural logarithm of all the fraction numbers. And, the result looks like this. πŸ‘‡

Natural Logarithm of Fractional Numbers

Read More: How to Calculate Antilog in Excel (With 3 Examples)


3. Calculate Natural Logarithm of a Negative Number

Now, you can not find a natural logarithm of a negative number. This will show you the #NUM! Error. Follow the steps below to test this. πŸ‘‡

πŸ“Œ Steps:

  • First, click on the cell where you want to put the natural logarithm result.
  • Subsequently, put an equal sign (=) and write LN. As a result, the LN function will be active. Now, refer to the B5 cell as you want to find the natural logarithm of this cell.
=LN(B5)

Use the LN Function to Calculate Natural Logarithm of Negative Numbers

  • Next, place your cursor at the bottom right corner of the result cell. Now, drag the fill handle below to copy the formula to all the cells below.

Copy the LN Formula

Thus, you can see the natural logarithm of all the negative numbers. And, the result looks like this. πŸ‘‡

Natural Logarithm of Negative Numbers

Read More: How to Do Inverse Log in Excel (3 Simple Methods)


4. Calculate Natural Logarithm of Zero

Just like the negative number, you can not find the natural logarithm of zeros too. This will also show you the #NUM! error. Follow the steps below to test this. πŸ‘‡

πŸ“Œ Steps:

  • First, click on the cell where you want to put the natural logarithm result.
  • Subsequently, put an equal sign (=) and write LN. As a result, the LN function will be active. Now, refer to the B5 cell as you want to find the natural logarithm of this cell.
=LN(B5)

Use the LN Function to Calculate the Natural Logarithm of Zero

  • Next, place your cursor at the bottom right corner of the result cell. Now, drag the fill handle below to copy the formula to all the cells below.

Copy the LN Function

Thus, you can see the natural logarithm of zeros. And, the result looks like this. πŸ‘‡

Natural Logarithm of Zeros

Read More: How to Make a Mileage Log in Excel (2 Handy Methods)


Quick Notes

  • LN function is the inverse of the EXP function.
  • The LN function returns you the natural logarithm of a number. Similarly, the LOG functionΒ returns a logarithm of a number to any base. Moreover, the LOG10 functionΒ returns the logarithm of a number to the base 10.

Conclusion

So, in this article, I have shown you 4 ideal examples to calculate natural logarithm in Excel. Follow these examples to accomplish your desired result. I hope you find this article helpful and informative. If you have any further queries or recommendations, please feel free to contact me. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo