LN Function in Excel

In this post you will learn about the LN Function in Excel, how to use it in your excel spreadsheets. The function is used to find the natural logarithm of the given number.

Syntax

=LN(number)

The syntax has a single argument

number – This holds the number for conversion

How to use LN Function in Excel?

  • This function is used to find the natural logarithm of the given number, natural numbers are based on the constant e.
  • The LN Function is an inverse of the EXP Function.
  • The Syntax works with integers and decimal numbers.

Example:

  • Start by entering the data in the excel sheet.
  • In a new cell enter the syntax an highlight the data cell to include it in the function.
How to use LN Function in Excel?
  • Press enter to display the answer.
How to use LN Function in Excel?
  • Use the fill handle to apply the function on the rest of the data.
How to use LN Function in Excel?

Additional points

  • To explain the relation of the LN function and the EXP function, we can look at the following expression
=LN(EXP(x)) = x
How to use LN Function in Excel?

The natural logarithm of x is taken to the power of the value x which returns x as the answer.

  • An equivalent form of the LN function is given below
=LN(number) = LOG(number, e)/(number, EXP(1))                  EXP(1) = e = 2.718281828459…
How to use LN Function in Excel?
How to use LN Function in Excel?
  • Note: The value is e is called the natural number, or Euler’s number. It is an important mathematical constant approximately equal to 2.718281828459…
  • The function does not accept Negative numbers and returns #NUM!.
  • The function returns #VALUE!, when a non – numeric value is used
How to use LN Function in Excel?