# EXP function in Excel

> EXP returns e (about 2.71828) raised to a power.

Source: https://spreadsheetpractice.com/functions/exp · 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:** EXP returns e (about 2.71828) raised to a power.
- **Syntax:** `=EXP(number)`
- **Most common use:** `=EXP(1)` returns 2.718281828 (e itself, about 2.71828)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** e raised to number.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

EXP returns e (about 2.71828) raised to a power. It's the inverse of LN and appears in continuous compounding, growth and decay models, and statistics. =EXP(1) gives you e itself.

## Syntax

`=EXP(number)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The power to raise e to. |

## Examples

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

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=EXP(1)` | 2.718281828 | e itself, about 2.71828 |
| D3 | `=B2*EXP(B3*B4)` | $5,637.48 | Balance after 3 years of continuous compounding at 4% |
| D4 | `=EXP(LN(B2))` | 5000 | EXP undoes LN, so this returns 5,000 again |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Input | Value |  |  |
| 2 | Principal | $5,000 |  | 2.718281828 |
| 3 | Rate | 4% |  | $5,637.48 |
| 4 | Years | 3 |  | 5000 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #NUM! | The result is too large for Excel: EXP of more than about 709 overflows. Check that the power isn't a whole-number percent. |
| Result is enormous | The rate was entered as 4 instead of 4% or 0.04, so EXP(4*3) is used instead of EXP(0.12). |
| Slightly off from a textbook answer | Typing 2.718 for e loses precision. Use EXP(x) rather than 2.718^x. |

## Tips

- Exponential decay, such as a half-life model: =Start*EXP(-Rate*Time).

## Related functions

- [LN](https://spreadsheetpractice.com/functions/ln): LN returns the natural logarithm of a number: the power you would raise e to in order to get it.
- [POWER](https://spreadsheetpractice.com/functions/power): POWER raises a number to a power, the same as the ^ operator.
- [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.

## Questions

### How do I enter e in Excel?

Use =EXP(1), which returns 2.71828182845905.

### What is the difference between EXP and POWER?

EXP always uses e as the base. POWER lets you choose the base: =POWER(2.71828,x) is close to EXP(x) but less precise.

### How do I calculate continuous compounding in Excel?

Use =P*EXP(r*t), for example =B2*EXP(C2*D2).

## Practice

A graded EXP exercise ("Continuous compounding") is on [the EXP page](https://spreadsheetpractice.com/functions/exp). 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.
