EXP Function in Microsoft Excel: Examples, Pitfalls & Compatibility
EXP in Microsoft Excel: calculate e raised to a power for an explicitly exponential model. Includes worked examples and application-specific cautions.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Microsoft Excel. How formula examples are checked
Quick answer: Use EXP in Microsoft Excel to calculate e raised to a power for an explicitly exponential model. The official EXP reference is the source for the function definition and platform-specific rules described below.
Syntax and arguments
=EXP(number)
number (required): The exponent applied to e, not an arbitrary base.
Examples use English function names, comma argument separators and decimal points. Adapt formula separators to your workbook settings, not punctuation inside quoted text.
When to use it
Use EXP when the model is expressed with the natural exponential e^x. Use POWER for another base. A percentage rate is not automatically a valid exponent: specify the model, units and time scale before multiplying a rate by time.
Three worked examples
Each example is independent. Where input cells are listed, enter those values first; otherwise the formula is self-contained. Expected outputs are independently checked calculations or documented error expectations, not captured results from Microsoft Excel.
Example 1: Calculate an exponential factor
=ROUND(EXP(0.5),6)
Expected result: 1.648721.
The result is e to the power one half, reported to six decimals.
Example 2: Apply a stated decay model
=ROUND(120*EXP(-0.2*3),6)
Expected result: 65.857396.
The assumed model starts at 120 and uses a rate of -0.2 per time unit for three units. The exponent is -0.6.
Example 3: Check the zero-time factor
=EXP(0)
Expected result: 1.
An exponent of zero gives the neutral multiplicative factor 1, not zero.
Put it to work safely
Keep the starting quantity, rate and elapsed time in labelled cells. For a decay model use a negative exponent; for a growth model use a positive one. Check that rate and time use compatible units so their product is dimensionless. Retain an explicit statement that a chosen exponential model is an assumption, not proof that real observations follow it.
Common mistakes and fixes
A negative exponent is expected to make the result negative. For a finite real exponent, the mathematical exponential is positive. A negative exponent gives a reciprocal factor, not a negative sign.
A different base is required. EXP always uses e. Use POWER or ^ for an explicitly chosen base.
A very large exponent fails. Finite-precision applications have representational limits. No overflow or underflow boundary is certified in this guide.
Microsoft Excel-specific notes
Microsoft documents EXP as the inverse of LN for appropriate real inputs. Use EXP(1) rather than a short manually typed decimal when the constant e is required inside a calculation. See the vendor reference for the current definition.
Excel and Google Sheets comparison
Both references describe the natural exponential. The finite examples are mathematical checks; they do not establish identical underflow, overflow or last-digit rounding across platforms.
Compare the EXP guide for Google Sheets and its official documentation. Having a guide in both libraries establishes two documented references, not a certificate of identical behavior across releases, locales or file conversions.
Related guides
LN, POWER, LOG, ROUND · All Microsoft Excel functions.
Evidence and testing scope
Editorial verification: Official references retrieved on 2026-10-12. The three worked cases are included in this release’s reproducible Python checking suite. It checks the stated arithmetic, calendar or text model and the expected documented error classification; it is not the Microsoft Excel calculation engine. No native application run, UI screenshot, maximum-size benchmark or cross-version certification is claimed. Review the editorial testing standards before relying on a formula in a critical workbook.