• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Natural Log in Excel

April 9, 2021 by Andrew Childress
How to find natural log in Excel

Finding natural logarithms may seem daunting. But it's easy when you use Excel. Let's learn how to calculate natural log with Excel.

Finding natural logarithms may seem daunting. But it’s easy when you use Excel. Let’s learn how to calculate natural log (LN) with Microsoft Excel.

You may have a list of existing numbers, and want to find the natural log of each one. Or, you may want to perform the calculation in a single cell on data that you input. We’ll explore both ways.

Find Natural Log for Existing Data

Suppose you have a list of five numbers, for which you need to calculate the natural logarithm. These five values are listed in cells A1, A2, A3, A4, and A5.

Begin by clicking into cell B1. Type an = sign to begin a formula. (Hint: each and every formula in Excel begins with an = sign).

Then, type LN, followed immediately by (. Then, click into cell A1, and you’ll see that cell reference populate into the Formula bar. Type ), and then press Enter.

Natural log in Excel

The LN value will calculate.

Now, thanks to Excel’s powerful features, there’s no need to type formulas again. With cell B1 selected, click and hold in the lower right corner of the cell when you see the + symbol appear.

Then, drag down through cells B2, B3, B4, and B5. Excel will automatically update your formula and return the natural log for each individual Column A value.

Ln in Excel

Find Natural Log of Any Number

In another scenario, you have no data in your cell. Someone may ask you what the LN of 100 is, for example. This is easy to calculate, and very similar to the steps above.

Click into any empty cell, and type the following formula:

=LN(100)

How to find natural log in Excel

Then press Enter. Notice that the only difference from the prior steps is that there is no cell reference (such as A1) in your formula. This just tells Excel to perform the calculation on the value 100, rather than on existing cell data.

Once again, your solution value appears in the cell where you entered the formula. Excel makes complex math equations easy with built-in features. With a few keystrokes, you’re performing advanced calculations fast.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Format axis titles Excel Axis Labels in Excel
Next Post: COUNTIF Function in Excel Countifs Function Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top