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, examples and any stated test scope below. How formula examples are checked
Availability and version history
- Introduced: Documented by Apache OpenOffice 4.1.16; original introduction not established.
- Availability: Supported in Apache OpenOffice 4.1.16, verified against its function registry. This identifies a supported release, not a final working version.
- Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
- Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
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) uses a rounded approximation to e and is not exactly equivalent; no performance comparison is established here.
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))
Mathematically recovers positive A1 when the intermediate calculation remains in range; floating rounding prevents a universal exact-equality promise.
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
The scalar callback applies exp to the numeric input. Mathematically EXP(x)>0 for every finite real x, but an implementation can underflow to zero for a sufficiently negative value or overflow for a large positive one. No exact platform threshold is asserted. The EXP(1000) boundary illustration concerns overflow in ordinary binary64 arithmetic rather than a new native run. A physically empty scalar reference reads as zero, whose EXP is 1.
For scalar numeric functions the checked reader distinguishes genuine empty references, strings, numeric values and errors. It can parse some numeric text, including ordinary integer text, and reads a physically empty referenced cell as zero. Therefore neither “all text is ignored” nor “all blanks always produce an invalid-argument error” is a safe general rule. A formula error propagates; it is not silently removed. Use explicit numeric cells in the reproducible tests, and inspect data types before changing a domain check.
Formula parsing errors are separate from mathematical domain errors. Check the function spelling, parentheses and the semicolon separator used in these examples. Number formatting affects display; the separate Calc precision-as-shown setting can also affect numeric reads, so the reference calculations assume ordinary stored-value precision. Dates and times are stored numeric values, but that does not make applying this mathematical operation physically meaningful to every date serial.
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
Reproducible numeric controls
| Formula | Independent reference result |
|---|---|
=EXP(0) |
1 |
=ROUND(EXP(1);10) |
2.7182818285 |
=ROUND(EXP(2);10) |
7.3890560989 |
=ROUND(EXP(-1);10) |
0.3678794412 |
=ROUND(EXP(0.5);10) |
1.6487212707 |
=ROUND(EXP(-2);10) |
0.1353352832 |
These are independent mathematical/source controls, not new native application or GUI observations. ERROR denotes an invalid or non-finite source path without inventing an observed localized message. Decimal expectations use the shown rounding precision; full stored results should be retained for subsequent arithmetic.
Complete worksheet and changed-input checks
Enter times 0,1,2,3 in A2:A5. In B2 enter =100*EXP(-0.2*A2) and fill down. Rounded to six decimals, values are 100,81.873075,67.032005,54.881164. Each one-unit interval multiplies the previous value by EXP(-0.2), approximately 0.8187307531. The change in the absolute amount is not constant.
For a positive exponent example, the retained =1000*EXP(0.05*10) gives approximately 1648.7212707001. Compare it with 1000*POWER(1.05;10), approximately 1628.8946267774: the same written 0.05 has different continuous and per-period meanings in these two mathematical models.
Advanced validation and model boundaries
Reverse the transformation within its usable range. For x=0.5, LN(EXP(x)) is mathematically 0.5. For a positive value 7, EXP(LN(7)) is mathematically 7. Numerical overflow, underflow and rounding can prevent universal exact round trips, so preserve stored precision and use a suitable tolerance.
Translate a continuous parameter. EXP(0.05)-1 is approximately 0.0512710964. In the reverse direction LN(1.05) is approximately 0.0487901642. These are different conversions, not evidence that 5% always means the same parameter in every exponential model.
Use a dimensionless exponent. In EXP(-k*t), k and t must have reciprocal units so their product is unitless. If k is per hour, converting t to minutes without changing k multiplies the intended exponent by 60. The function cannot validate those physical units.
Documentation and verification scope
The original useful examples, named-variable illustrations, shortcodes and design are retained; variables such as Radius, Rate, sd or Time must be defined as cells/names with the required units before those templates are executable. The earlier cross-sheet and Ctrl+Shift+Enter examples describe formula patterns, not a new GUI or array-entry test. Compatibility metadata does not certify identical coercion or boundary behavior in other products.
See the official EXP reference, 4.1.16 mathematics help, scalar elementary functions, SIGN and logarithm callbacks, POWER implementation, numeric argument reading, and non-finite result handling. The first help/core snapshots retain October 13 retrieval dates; POWER retains October 14. Numeric-reader and result-handler sources were retrieved October 15. Original introduction and final functioning version remain unknown; the supported 4.1.16 evidence above is separate.