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

ArgumentRequired?What it does
numberYesA positive number.

Examples

Example 1 — Monthly log returns

The natural log of this month's price over last month's.

C3fx=LN(B3/B2)
ABC
1MonthPriceLog return
2Jan100
3Feb1050.0488
4Mar99.75-0.0513
=LN(B3/B2) Explain

Common mistakes

  • Zero or negative. LN(0) and LN of negatives return #NUM!.

Notes

  • Related functions: EXP, LOG, LOG10.
Kyle Stott

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.