EXP Function
Returns e raised to a power.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Want to practice EXP 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
EXP(n) calculates e (about 2.71828) to the power n. It's the reverse of LN.
It appears in continuous compounding, growth and decay models and some statistical formulas.
Syntax
=EXP(number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The power to raise e to. |
Examples
Example 1 — Continuous compounding
$1,000 at 5% compounded continuously for each number of years.
B2fx=1000*EXP(5%*A2)
| A | B | |
|---|---|---|
| 1 | Years | Value |
| 2 | 1 | 1051.27 |
| 3 | 5 | 1284.03 |
| 4 | 10 | 1648.72 |
=1000*EXP(5%*A2) Explain
Common mistakes
- Huge results. EXP of anything above about 709 is too large for Excel and returns #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.