## What Is LN Function In Excel?

The

LN Function in Excelcalculates the natural logarithm of a given number. The function is categorized under the Math & Trig function from the Function Library.

The **LN Function **denotes the logarithm statement, and as per the syntax, we put the number of logarithm values we need to find; we can choose any exponential or raise to power value in the syntax. For example, consider the below table with a value in cell A1. We need to use the below steps to obtain the result with LN Excel Function.

The steps used to find the log value in Excel are as follows. To begin with, select the cell to display the result. In this example, we have selected cell A1. Next, enter the LN formula in cell A1. So, the complete formula is **=LN(2)**. Then, press **Enter** key. We can clearly see that the function has returned the log value in cell A1.

Similarly, we can use LN function to fetch the log value.

##### Table of contents

###### Key Takeaways

- The LN Excel Function is used to find the log values.
- The LN Excel formula is
**=LN(number)**where*,*denotes the number we assign to get the natural logarithm number.**number** - The natural logarithm is related to the EXP function. In EXP, the value of a base number is raised to an exponential number; in the logarithm, so, we need to know the exponential number to get the desired number.
- If the parameter is a negative number, it returns an error with #NUM! thus, indicating an error with the number.

### LN() Excel Formula

The syntax of the **LN Excel formula **is

*where, number* is the mandatory argument and it denotes the number we assign to get the natural logarithm number.

**Excel VBA – All in One Courses Bundle (35+ Hours of Video Tutorials)**

**Excel VBA – All in One Courses Bundle (35+ Hours of Video Tutorials)**

If you want to learn Excel and VBA professionally, then Excel VBA All in One Courses Bundle (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

### How To Use LN Excel Function?

We can insert LN Excel function using the below two methods.

#### Method #1 – Access From The Excel Ribbon

- 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. - Similarly, select
**LN**from the drop-down menu.

- A window called
**Function Arguments**appears. - As the number of arguments, enter the value in the
**number.** - Select
**OK.**

#### Method #2 – Enter The Worksheet Manually

- 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 the
**Enter**key.

#### Basic Example

The below table shows the values in column A. We need to use the below steps to find log values using LN Excel Function.

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

**First, select the cell where we will enter the formula and calculate the result. The selected cell, in this case, is cell B2.****Next, we will enter the LN formula in cell B2.****Then, enter the value of ‘number’ as A2.****So, the complete formula is =LN(A2) in cell B2.****Then, press Enter key.**

Clearly, we can see that the function has returned the result in cell B2 as 0.**Now, drag the cursor to cell B5, as shown in the following image.**

Similarly, we can use LN Excel Function to get the log value.

### Examples

#### Example #1

The following table shows the fractional values in column A. We need to use the below steps to find log value using LN Excel Function.

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

**Step 1:**To begin with, 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:**Enter the value of ‘number’ as A2, i.e., the fraction number value.

**Step 4:**So, the complete formula is**=LN(A2)**in cell B2.

**Step 5:**Press the**Enter**key.

Clearly, we can see that the function has returned the result in cell B2 as 0.207.

**Step 6:**Next, drag the cursor to cell B5, as shown in the following image.

Similarly, we can use the function to find the log values.

#### Example #2

The below table shows zero value in cell A2. We need to use the below steps to calculate the log values with LN Excel Function.

The steps to evaluate the values by the **LN 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 zero value.

**Step 4:**So, the complete formula is**=LN(A2)**in cell B2.

**Step 5:**Finally, press**Enter**key.

Clearly, we can see that the function has returned the result in cell B2 as **#NUM!** error.

Likewise, we can use the function to obtain log values.

#### Example #3

The following table shows non-numeric value in cell A2. We need to use the below steps to calculate the log values with LN Excel Function.

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

**Step 1:**First, select the cell where we will enter the formula and calculate the result. So, 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 non-numeric value.

**Step 4:**So, the complete formula is**=LN(A2)**in cell B2.

**Step 5:**Next, press**Enter**key.

So, we can see that the function has returned the result in cell B2 as **#VALUE!** error.

Likewise, we can use the function.

#### Example #4

The below table shows negative number value in cell A2. We need to use the below steps to calculate the log values with LN Excel Function.

The steps to evaluate the values by the **LN Function in Excel **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 negative number value.

**Step 4:**So, the complete formula is**=LN(A2)**in cell B2.

**Step 5:**Press**Enter**key.

Clearly, we can see that the function has returned the result in cell B2 as **#NUM!** error.

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

### Important Things To Note

- The LN Excel Function is a built-in function used to calculate log values in excel.
- The function is available under Math & Trig function and accepts only a positive real number as its parameter.
- The #NUM! error occurs when the value entered as a parameter is zero.
- The #VALUE! error occurs when the parameter is a non-numeric value.
- The divisor of the number cannot be zero.
- The #NUM! error occurs when the value entered as a parameter is a negative number.

### Frequently Asked Questions (FAQs)

**1. What does the LN function do in Excel?**

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)**

**2. How to calculate the LN Function in Excel?**

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.

**3. Where is the LN Function in Excel?**

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.**

### Download Template

This article must help understand the **LN Excel Function’s** formula and examples. You can download the template here to use it instantly.

### Recommended Articles

This has been a guide to LN Excel Function. Here we learn to use the LN() formula along with step-by-step examples and a downloadable excel template. You can learn more from the following articles –

## Leave a Reply