FormulaCraft

EXP

EXP computes the mathematical constant e (approximately 2.71828) raised to the power of the supplied number. It is the inverse of LN and appears frequently in compound interest, population growth, and probability formulas.

Excel
=EXP(A2)
Google Sheets
=EXP(A2)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

ExponentResult
0
1
2
3

=EXP(A2)→1

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

  1. 1A2 is the exponent — the power to which e is raised (e.g. 1 returns ≈ 2.71828).
  2. 2EXP(0) always equals 1; EXP(1) equals Euler's number e.
  3. 3Combine with LN to model continuous growth: ending value = start * EXP(rate * time).

Need a version for your data?

Try: “Calculate e raised to the power of each value in my column”

Related

SUMIFSUMIFSCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: