LN Excel Formula

Author Zaheer    Category Formulas     Tags ,

Due to the rapid advancements in technology, tasks get even more complicated. And so with this, people need to cope with the increasing complexity of different tasks. So along with the rapid developments in the techno-world, a very useful software program was skillfully created and designed by the Microsoft Company, which is the Microsoft Excel. Excel incorporates lots of powerful functions and formulas that can help people to accomplish their tasks in a very quick and easy manner.

This software program is widely used in different fields like business, science, and engineering and especially in mathematics. Excel features several mathematical functions that have the ability to perform simple and complex calculations. One of these functions is the LN function which computes for the natural logarithm of a given number. This article will provide you relevant information to help you learn about the LN function. But before that, let’s have first a brief overview about the natural logarithm.

What is Natural Logarithm?

The logarithm of a numerical value, to a given base, is the exponent to which the base should be raised to result to that numerical value. The natural logarithm of a numerical value, (written as Loge(x) or Ln(x) is the logarithm to a given base which is e.

Thus, the equation for the natural logarithm is:

If ex = y then Ln(y) = x

Now that you already know the general concept behind the natural logarithm, you can now go further and learn about the LN function in Microsoft Excel.

Description of the LN Function in Excel

The LN function in MS Excel is used to compute for the natural logarithm of a supplied numerical value. The formula of this particular function is as under:

LN (number)

In this formula, the number argument refers to a real number that carries a positive sign that you want to compute the natural logarithm of.

Example on the Usage of the LN Function in Microsoft Excel

These examples below will show you on how to use the LN function to compute for the natural logarithm of different numerical values.

  • Let’s say that you want to find the natural logarithm of 1. You can do this in Excel by using this formula, =LN (1). You can type in this formula in any cell where you want the result to be displayed. Then the function will return the result which is 0. As mentioned earlier, the natural logarithm of a number is the power to which the base e should be raised to result to the number. You can see what this means by referring to this equation, e0 = 1; therefore, LN (1) = 0.
  • Here’s another one, type in this formula in any cell if you want to find the natural logarithm of 100, =LN (100). The function will return the function which is 4.605170186. Refer to this equation, e4.605170186 = 100; thus, LN (100) = 4.605170186.
  • Then finally, you can use this formula if you want to calculate for the natural logarithm of 0.5, =LN (0.5). The function will return the result which is -0.693147181. Then refer to this equation, e-0.693147181 = 0.5; thus, LN (0.5) = -0.693147181.

Common Errors in the LN Function in Excel

If you obtain an error in using the LN function while operating Excel, it might be caused by the following:

  • #NUM! – This error value is displayed if the supplied numerical value is zero or a negative number.
  • #NAME? – This error value is displayed if the supplied number argument is a non-numeric value.

Post comment