LN Function
Returns the natural logarithm (base e) of a number.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Want to practice LN in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
LN answers “e to what power gives this number?”. It's the reverse of EXP.
Analysts use it for log returns and to turn exponential growth into a straight line.
Syntax
=LN(number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | A positive number. |
Examples
Example 1 — Monthly log returns
The natural log of this month's price over last month's.
C3fx=LN(B3/B2)
| A | B | C | |
|---|---|---|---|
| 1 | Month | Price | Log return |
| 2 | Jan | 100 | |
| 3 | Feb | 105 | 0.0488 |
| 4 | Mar | 99.75 | -0.0513 |
=LN(B3/B2) Explain
Common mistakes
- Zero or negative. LN(0) and LN of negatives return #NUM!.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.