# How to Calculate Natural Logarithm in Excel (4 Methods)

### What Is a 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. You can find the natural logarithm of positive numbers only.

### The LN Function in Excel

The LN function returns the natural logarithm of a number in Excel. It has one argument onlyâ€”number.

Note: Zero or negative numbers will result in #NUM! error and non-numeric values in the #VALUE! error.

Suppose you have the following dataset.

### Method 1 – Calculating the Natural Logarithm of a Positive Integer Number

Steps:

• Click on the cell where you want the result.
• Enter the following formula.
`=LN(B5)`
• Press Enter.

• Use the Autofill Tool to copy the formula to the remaining cells in the column.

The results should look like this.

Read More: How to Log Transform Data in ExcelÂ

### Method 2 – Calculating the Natural Logarithm of a Fractional Number

Steps:

• Click on the cell where you want the result.
• Enter the following formula.
`=LN(B5)`
• Press Enter.

• Use the Autofill Tool to copy the formula to the remaining cells in the column.

The results should look like this.

### Method 3 – Obtaining the Natural Logarithm of a Negative Number in Excel

Steps:

• Click on the cell where you want the result.
• Enter the following formula.
`=LN(B5)`
• Press Enter.

• Use the Autofill Tool to copy the formula to the remaining cells in the column.

The results should look like this.

### Method 4 – Calculating the Natural Logarithm of Zero

Steps:

• Click on the cell where you want the result.
• Enter the following formula.
`=LN(B5)`
• Press Enter.

• Use the Autofill Tool to copy the formula to the remaining cells in the column.

The results should look like this.

Read More: Â How to Calculate Log Base 2 in ExcelÂ

### Things to Remember

• The LN function is the inverse of the EXP function.
• The LOG function returns a logarithm of a number to any base, and the LOG10 functionÂ returns the logarithm of a number to the base 10.

## Related Articles

<< Go Back toÂ Excel LOG Function | Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF