EXP
Math & Trig
Returns e raised to the power of a given number.
Translations
EnglishEXP
FrenchEXP
SpanishEXP
GermanEXP
ItalianESP
PortugueseEXP
DutchEXP
PolishEXP
RussianEXP
TurkishÜS
CzechEXP
HungarianKITEVŐ
SwedishEXP
DanishEKSP
FinnishEKSPONENTTI
Syntax
EXP(number)Arguments
numberThe exponent
Examples
=EXP(1)2.718...
Value of e
=EXP(0)1
Any number to power 0 is 1
=EXP(LN(10))10
EXP reverses LN
Tips & Best Practices
- •EXP is the inverse of LN
- •Used in exponential growth models
- •EXP(1) returns the constant e
Common Mistakes
- •Confusing EXP(x) with raising 10 to a power - EXP always uses the mathematical constant e (approximately 2.71828) as its base, not 10
- •Using EXP for very large exponents and getting a #NUM! error, since the result exceeds Excel's maximum representable number
- •Forgetting that EXP and LN are inverse operations, leading to unnecessarily nested formulas like EXP(LN(x)) when x alone would work
Related Functions
LNPerforms the inverse operation - calculates the natural logarithm, undoing what EXP calculates.POWERCan replicate EXP using POWER(EXP(1),number), though EXP is more direct and readable for this specific case.LOGCalculates a logarithm with any base, related to EXP through the natural logarithm case when base equals e.Frequently Asked Questions
What does EXP actually calculate?
It raises e (approximately 2.71828) to the power you specify - EXP(1) returns e itself, roughly 2.71828.
Why does EXP return #NUM!?
The exponent supplied is too large, producing a result beyond Excel's maximum representable number - very large inputs to EXP grow extremely fast.
How do I undo an EXP calculation?
Use LN (natural logarithm) - if EXP(x) gives a result, LN of that result returns you to x.
Need to translate a formula using EXP?
Use our translator to convert your complete formula