Syntax
EXP(number)
| Parameter | Description |
|---|---|
| number | Parameter of the EXP function. |
Examples
Euler's number
Formula
=EXP(1)
Returns ~2.71828. This is the value of e itself, the base of natural logarithms.
Continuous compounding
Formula
=1000*EXP(0.05*10)
Returns ~1,648.72. $1,000 invested at 5% continuously compounded for 10 years grows to $1,648.72 (using the formula P×e^(rt)).
Inverse of LN
Formula
=EXP(LN(50))
Returns 50. EXP and LN are inverse functions: EXP(LN(x)) = x for any positive x.
Common Errors
#VALUE!
Non-numeric input returns #VALUE!. The argument must be a number.
#NUM!
Very large arguments (e.g., EXP(710)) overflow the number format and return #NUM!.
Tips
Continuous compound interest
Future value = Principal × EXP(rate × time). This is the limit of compound interest as compounding frequency approaches infinity.
Decay and half-life
Radioactive decay: remaining = initial × EXP(-decay_constant × time). Set remaining = initial/2 and solve for time to get the half-life.
Normal distribution
The normal distribution bell curve uses EXP(-x²/2). Many statistical functions are built on EXP internally.
Try EXP in Viztab
Import your data and use EXP with 370+ other formulas. No signup required.
Open Viztab