EXP Function in Google Sheets: Examples, Pitfalls & Compatibility

=EXP(exponent)

exponent (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.

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.

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 Google Sheets.

Example 1: Calculate a quarter-unit exponent

=ROUND(EXP(0.25),6)

Expected result: 1.284025.

This is an exponential factor, not a percentage automatically attached to a real-world process.

Example 2: Evaluate a separate decay example

=ROUND(80*EXP(-0.1*4),6)

Expected result: 53.625604.

The assumed decay exponent is -0.4. The rate and elapsed time must refer to the same time unit.

Example 3: Check the identity factor

=EXP(0)

Expected result: 1.

This is a useful baseline when a time-dependent exponent should become zero at the start of the model.

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.

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.

Google defines the argument as the exponent applied to Euler’s number. The examples below use that definition directly rather than approximating e with a typed three-decimal constant. See the vendor reference for the current definition.

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 Microsoft Excel 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.

LN, POWER, LOG, ROUND · All Google Sheets functions.

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 Google Sheets 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.