# LN function in Excel

> LN returns the natural logarithm of a number: the power you would raise e to in order to get it.

Source: https://spreadsheetpractice.com/functions/ln · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** LN returns the natural logarithm of a number: the power you would raise e to in order to get it.
- **Syntax:** `=LN(number)`
- **Most common use:** `=LN(B2)` returns 7.090076836 (Natural log of 1,200: about 7.09)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The natural (base e) logarithm.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

LN returns the natural logarithm of a number: the power you would raise e to in order to get it. In finance and analytics it turns growth into an additive rate, which is why log returns and continuous growth rates use it. It's the inverse of EXP.

## Syntax

`=LN(number)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | A positive number. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=LN(B2)` | 7.090076836 | Natural log of 1,200: about 7.09 |
| D3 | `=LN(B3/B2)/B4` | 10.8% | Average continuous growth rate per year: about 10.8% |
| D4 | `=LN(0)` | #NUM! | #NUM!: zero and negative numbers have no logarithm |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Input | Value |  |  |
| 2 | Start value | 1200 |  | 7.090076836 |
| 3 | End value | 1850 |  | 10.8% |
| 4 | Years | 4 |  | #NUM! |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #NUM! | The number is zero or negative. Check for empty cells or losses before taking the log of a ratio. |
| Wanted base 10 | LN uses base e. Use LOG10, or LOG with no base, for base 10. |
| #DIV/0! | The ratio inside LN divides by an empty or zero cell, such as a missing start value. |

## Tips

- Log returns add up across periods: the sum of monthly LN(end/start) values equals the log return for the year.

## Related functions

- [EXP](https://spreadsheetpractice.com/functions/exp): EXP returns e (about 2.71828) raised to a power.
- [LOG](https://spreadsheetpractice.com/functions/log): LOG returns the logarithm of a number in the base you choose: the power the base must be raised to in order to reach the number.
- [LOG10](https://spreadsheetpractice.com/functions/log10): LOG10 returns the base-10 logarithm of a number: how many times 10 is multiplied to reach it.

## Questions

### What is the difference between LN and LOG in Excel?

LN is the natural log (base e). LOG defaults to base 10 and accepts any base as a second argument.

### How do I calculate a log return in Excel?

Use =LN(End/Start), for example =LN(C2/B2).

### How do I undo LN?

Use EXP: =EXP(LN(A2)) returns A2.

## Practice

A graded LN exercise ("Log returns") is on [the LN page](https://spreadsheetpractice.com/functions/ln). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
