EXP function

EXP returns e raised to the power of a number, calculating natural exponential growth or decay for financial and scientific modeling.

=EXP(number)

Generate a EXP formula

Describe what you need. The generator will reach for EXP where EXP is the right tool, and tell you when it is not.

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

How EXP reads its arguments
numberrequiredEXP →
ArgumentRequiredDescription
numberRequiredThe exponent to apply to the mathematical constant e. Must be numeric; positive values yield results > 1, negative values yield results between 0 and 1, and 0 yields exactly 1. Exponents larger than approximately 700 cause #NUM! overflow.

Returns

A positive numeric value representing e^number, where e ≈ 2.71828.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Model ingredient spoilage decay rate over storage time

IngredientDays StoredDaily Decay RateQuality Remaining
Tomatoes7-0.1=ROUND(EXP(-0.1*7),4)
=ROUND(EXP(-0.1*7),4)

Result: 0.4966

This exponential decay calculation shows tomatoes retain 49.66% of their original quality after 7 days at a 10% daily decay rate. The negative exponent (-0.7) produces a fraction less than 1, modeling how perishable goods lose value continuously. Restaurants use this to determine when ingredients should move to specials pricing or be discarded to minimize waste.

2. Project supplier cost inflation using continuous compounding

SupplierAnnual Growth RateYears OutCost Multiplier
DiCarlo0.083=ROUND(EXP(0.08*3),4)
=ROUND(EXP(0.08*3),4)

Result: 1.2712

An 8% annual growth rate compounded continuously over 3 years yields a cost multiplier of 1.2712. If olive oil currently costs $100 per liter, expect $127.12 three years forward. This exponential model is more precise than discrete year-over-year multiplication for long-term planning, because EXP assumes cost increases happen continuously every moment, not once per year.

3. Calculate quality premium multiplier for tiered supplier pricing

IngredientQuality Rating FactorPrice Premium Index
Mozzarella0.5=ROUND(EXP(0.5),4)
=ROUND(EXP(0.5),4)

Result: 1.6487

A quality factor of 0.5 yields a price premium index of 1.6487, reflecting premium-grade mozzarella. Higher quality factors produce exponentially higher indices—a factor of 1.0 gives e≈2.7183, factor of 1.5 gives ≈4.48. This non-linear scaling rewards top suppliers and reflects how diners perceive quality improvements as exponential, justifying premium menu prices.

Common errors

Which EXP error are you seeing?
EXP returned an error#VALUE!
Ensure the argument is purely numeric. If the input is a cell, check its contents for hidden text or spaces. Convert text numbers using VALUE(): =EXP(VALUE(C2)). Delete non-numeric characters before calculating.
#NUM!
Use smaller exponent values or rescale your data. Divide the input by a constant: =EXP(input/10) instead of =EXP(input). Alternatively, use logarithm algebra to rearrange the formula before exponentiating.
#REF!
Verify all cell references point to actual, existing cells in the sheet. Use Trace Dependents (in Excel) or check cell references manually. Recreate the formula with valid cell addresses by clicking the cells directly.
ErrorWhy it happensHow to fix it
#VALUE!The argument is text or a reference to a text cell that cannot convert to a number. Example: =EXP("organic") or =EXP(C2) where C2 contains "premium supplier" instead of a number.Ensure the argument is purely numeric. If the input is a cell, check its contents for hidden text or spaces. Convert text numbers using VALUE(): =EXP(VALUE(C2)). Delete non-numeric characters before calculating.
#NUM!The exponent is too large, causing e^number to exceed the spreadsheet's maximum representable value. For example, =EXP(1000) attempts to calculate e^1000 ≈ 10^434, which is astronomically beyond any computer's numeric limits.Use smaller exponent values or rescale your data. Divide the input by a constant: =EXP(input/10) instead of =EXP(input). Alternatively, use logarithm algebra to rearrange the formula before exponentiating.
#REF!The formula references a deleted column or non-existent cell. Example: =EXP(ZZ2) if column ZZ doesn't exist, or =EXP(A1) after column A has been deleted from the sheet.Verify all cell references point to actual, existing cells in the sheet. Use Trace Dependents (in Excel) or check cell references manually. Recreate the formula with valid cell addresses by clicking the cells directly.

Tips and when to use something else

  • EXP always returns positive values. Negative exponents like EXP(-2) produce small decimals (≈0.135), making EXP perfect for decay models like spoilage or half-life calculations.
  • Use SUMPRODUCT to aggregate exponential effects across multiple rows without helper columns: =SUMPRODUCT(EXP(range)) efficiently sums all exponential values at once.
  • For discrete periodic growth (annual price increases), use IF with POWER instead: =IF(year>0,POWER(1.05,year),1) is clearer than EXP equivalents for non-technical users.
  • If results overflow with #NUM!, scale the calculation: split EXP(1000) as =POWER(EXP(100),10) or use logarithms to work around the overflow.

Related functions

ROUNDROUND returns a number rounded to a specified number of decimal places, using standard rounding rules (0.5 rounds up).SUMPRODUCTSUMPRODUCT multiplies arrays element-by-element and sums the results, useful for weighted totals and multi-criteria counting.IFThe IF function returns one value if a condition is true and another (or nothing) if it is false, letting you branch logic in a cell.IFERRORIFERROR returns the result of a formula unless that formula generates an error, in which case it returns a user-specified alternative value.

Frequently asked questions

What is the mathematical constant e and why does EXP use it?
e ≈ 2.71828 is the base of natural logarithms and represents the limit of continuous compounding. It appears naturally in finance (continuous interest), biology (population growth), and physics (half-life). EXP(n) is the inverse of LN, making it essential for solving exponential equations and modeling real-world continuous processes.
When should I use EXP instead of POWER for growth calculations?
Use EXP(rate*time) for continuous compounding that happens every infinitesimal moment. Use POWER(1+rate,time) for discrete compounding (once per period). Example: 5% growth for 10 years gives EXP(0.05*10)≈1.6487 (continuous) vs. POWER(1.05,10)≈1.6289 (annual). EXP is more accurate for real-world processes like inflation, decay, or biological growth.
Why does EXP always return positive numbers, even with negative inputs?
Mathematically, e^x is always positive for any real number x. EXP(0)=1, EXP(-10)≈0.000045, EXP(10)≈22026. This property makes EXP ideal for modeling physical quantities that can never be negative, like concentrations, probabilities, decay factors, or quality scores.
Can I reverse an EXP calculation to find the original exponent?
Yes, using the LN function: if you calculated =EXP(0.5)=1.6487, you recover the exponent with =LN(1.6487)=0.5. This inverse relationship is useful when solving for rates or exponents from known results, common in financial modeling and cost forecasting.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17