LN Excel Function

The LN Function in Excel is a logarithm function in arithmetic operations. The LN Function takes a single number as the argument and shows the result as the logarithm. It is a built-in function in MS Excel. The LN Excel function is categorized under Math & Trig functions in Excel.

The syntax of the LN function is =LN(number)

We can insert LN Excel Function using the below steps:
• Select an empty cell for the output.
• Type =LN() in the selected cell. Alternatively, type =L and double-click the LN function from the list of suggestions shown by Excel.
• Press Enter key.

For example, consider the below table with a single value in cell A2. We need to use the below steps to obtain the result using LN Function.



The steps to evaluate the values by the LN Excel Function are as follows:

• Step 1: First, select the cell where we will enter the formula and calculate the result. The selected cell, in this case, is cell B2.
• Step 2: Next, we will enter the LN formula in cell B2.
• Step 3: Then, enter the value of ‘number’ as A2, i.e., the single integer number value. 
• Step 4: So, the complete formula is =LN(A2) in cell B2.
• Step 5: Next, press Enter key.
Clearly, the function has returned the result in cell B2 as 2.4849.



Similarly, we can use LN Excel Function to fetch the log values.

We can insert LN Function in Excel using the following steps:
• To begin with, choose the empty cell which will contain the result.
• Next, go to the Formulas tab.
• Then, select the Math & Trig option from the menu.
• Now, select LN from the drop-down menu.
• A window called Function Arguments appears.
• As the number of arguments, enter the value in the number. 
• Finally, select OK.