Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
LN
LN calculates the natural logarithm of a positive number — the power to which e must be raised to produce that number. It is the inverse of EXP and is commonly used in financial models, growth-rate calculations, and statistical transforms.
Excel
=LN(A2)Google Sheets
=LN(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Value | LN Result |
| 1 | |
| 10 | |
| 100 | |
| 1000 |
=LN(A2)→0
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 must be a positive number — LN is undefined for zero or negative values.
- 2LN(1) = 0 and LN(e) = 1 since e^1 = e.
- 3To find continuous growth rate: LN(end_value / start_value) / periods.