Skip to Content

How to Use the LN Function in Google Sheets

Spreadsheet programs like Google Sheets can save you a lot of time when you are doing advanced calculations.

They have a ton of mathematical functions to help you perform whatever sorts of calculations you need. One such function is the LN function.

In this tutorial, I will cover how to use the LN function in Google Sheets.

What is the LN Function?

In Google Sheets, the LN function will return the natural logarithm of a value. It calculates this value using Euler’s number (e).

Euler’s number is a mathematical constant that is the base of the natural logarithm.

Google Sheets makes calculating this logarithm easy with the LN function.

The syntax of the LN function is:


  • value – this is the value that you want to calculate the logarithm (base e) for. It has to be a positive number. You can either place a value in the formula or use a cell reference.

Using the LN Function

Since the LN function only requires one argument, using it is very simple:

  1. Select the cell where you want to start the formula and press and Equals sign on your keyboard (=)
  2. Type LN and press Tab
  3. Select the cell that contains the value you want to calculate the logarithm for
  4. Add your closing parenthesis and press Enter to calculate the formula

LN function example-1

Closing Thoughts

Natural logarithms are important in many areas of math and science. Using the LN function in Google Sheets will offer you many advantages when you need to make this calculation.

Hopefully, now you can see how a spreadsheet program can greatly speed up your time performing a variety of tasks.

More Google Sheets Tutorials:
How to Do Factorials