EXP Function (OpenOffice Calc)
The EXP function in OpenOffice Calc returns e raised to a given power. Learn syntax, exponential growth behavior, examples, and best practices.
Verification status: Consult the documentation and examples below. Native application testing has not been documented for this guide. How formula examples are checked
The EXP function in OpenOffice Calc returns the value of the mathematical constant e (approximately 2.718281828…) raised to a given power. EXP is essential for continuous growth modeling, natural logarithms, compound interest, probability distributions, and scientific calculations.
What the EXP Function Does
- Computes ( e^x )
- Supports positive, negative, and fractional exponents
- Useful for continuous growth, decay, and probability models
- Works across sheets
- Pairs naturally with LN and LOG
EXP is ideal when you need natural exponential behavior.
Syntax
EXP(number)
Arguments:
- number — The exponent applied to e
POWER(2.718281828; number)but far more precise and efficient.
Basic Examples
e raised to a power
=EXP(1)
Result: 2.718281828…
e²
=EXP(2)
e⁻¹ (reciprocal)
=EXP(-1)
Result: 0.367879441…
Exponential growth factor
=EXP(0.5)
Advanced Examples
Continuous compound interest
Formula:
[ A = P \cdot e^{rt} ]
Calc:
=Principal * EXP(Rate * Time)
Example:
=1000 * EXP(0.05 * 10)
Exponential decay
=EXP(-0.3 * A1)
Natural log reversal
=EXP(LN(A1))
Always returns A1 (for positive A1).
EXP across sheets
=EXP(Sheet1.A1)
Probability density (normal distribution core)
=EXP(-POWER((x - mean) / sd; 2) / 2)
Logistic growth denominator
=1 + EXP(-k * (x - x0))
EXP in array formulas
=EXP(A1:A10)
Confirm with Ctrl+Shift+Enter.
Convert continuous rate to discrete rate
=EXP(r) - 1
Convert discrete rate to continuous rate
=LN(1 + r)
Common Errors and Fixes
EXP returns Err:503 (Numeric overflow)
Occurs when:
- The exponent is too large
- Result exceeds Calc’s numeric limits
Example: EXP(1000) will overflow.
EXP returns Err:502 (Invalid argument)
Occurs when:
- Input is text
- Input is empty
- A malformed reference is used
EXP returns unexpected results
Possible causes:
- Misunderstanding continuous vs discrete growth
- Negative exponents producing decay
- Text numbers not converted to numeric
EXP ignores values you expected it to include
EXP ignores:
- Text numbers (
"123") - Empty cells
- Logical values
- Errors
EXP includes values you expected it to ignore
EXP includes:
- Dates
- Times
- Numeric results of formulas
Err:508 — Missing parenthesis
Usually caused by:
- Missing
) - Using commas instead of semicolons
Best Practices
- Use EXP for continuous growth and decay
- Pair EXP with LN for reversible transformations
- Avoid extremely large exponents to prevent overflow
- Convert imported text numbers to real numbers
- Use named ranges for cleaner formulas
- Use EXP for probability distributions and scientific models