EXP in SoftMaker PlanMaker 2026: exponential growth and decay

EXP(x) returns e^x, making it useful for continuously compounded rates, modeled exponential growth and decay, transforming natural logarithms back into positive numbers, and sigmoid-style numerical transformations. The base cannot be changed within EXP: to calculate 2^x or 10^x, use a suitable numeric exponent expression or the separately documented POWER function. SoftMaker documents LN as the inverse of EXP.

=EXP(Number)

EXP in the English manual has one required argument, not EXP(Base,Exponent). The argument may be zero, negative or positive in the mathematical real-valued expression e^x; SoftMaker’s function entry states the operation but does not publish numeric overflow boundaries, text/blank coercion rules, or exact error codes, so this tutorial does not claim runtime behavior for those cases. Both PlanMaker 2026 EXP and PlanMaker 2024 EXP independently document this signature and the inverse LN relationship (checked 2026-10-13). No separate English-language EXP alias is documented there.

PlanMaker requires a leading = for calculations entered into cells. The English help examples use EXP(5) with a decimal-point convention, but SoftMaker documents that localized function names exist in non-English UIs language cross-reference and decimal separators may follow system or custom settings Edit tab. EXP itself has one argument so there is no argument delimiter in its basic syntax; multi-argument functions around it may differ by locale. No alternate locale was executed during research.

In a new worksheet, type Exponent in A1 and EXP result in B1. Enter the numeric exponents in A2:A9, and use =EXP(A2) in B2, filling downward. Display B to 10 decimal places for comparison. All numbers in the expected column are independently evaluated using the mathematical exponential function; they are not screenshots or native PlanMaker results.

The vendor’s own example EXP(5) returns approximately 148.4132; the more precise table value is an independent calculation. SoftMaker 2026 EXP. Small positive exponents create factors just above one, while negative exponents give factors between zero and one mathematically. This is not the same as claiming a guaranteed numeric precision or representable range in every PlanMaker edition.

Easy cross-checks with LN and POWER

• =EXP(0) → independently 1.
• =EXP(LN(0.1234)) → independently 0.1234, as also given by SoftMaker’s EXP help source.
• =LN(EXP(1.234)) → independently 1.234, also a SoftMaker LN example.
• =EXP(LN(2)*3) → independently 8, using a logarithm to produce a cube; =POWER(2,3) expresses the same intent more directly POWER.
• =EXP(-1) → independently approximately 0.3678794412, an exponential decay factor.

Let A12 hold the starting balance 1000, B12 the continuously compounded annual rate 0.05 (5% stored as a decimal), and C12 the elapsed time 3 years. In D12 enter:

=A12*EXP(B12*C12)

Independent expected ending balance: 1161.83424273. The underlying model is A(t)=A0*e^(r*t); EXP returns the factor e^(rate*time), and multiplication applies it to the starting amount. The rate and time units must agree (annual rate with years). This mathematical model does not include fees, taxes, varying rates, or market uncertainty; it is an illustrative exponential formula, not investment advice. The EXP call is grounded in vendor syntax; the model and numerical result are independently derived.

Equivalent effective annual growth factor

With a continuously compounded annual rate B15=0.06, enter:

=EXP(B15)-1

The independently expected effective one-year fractional growth is 0.0618365465, or 6.183655%. Format as Percentage if desired. This conversion is mathematical and assumes that B15 is a constant continuous-compounding rate, not the integer 6. Keep the formula as a rate fraction before deciding on display formatting.

Set A18=1000 (starting quantity), B18=0.2 (positive annual decay constant), C18=4 (years), then D18:

=A18*EXP(-B18*C18)

Independent expected remainder: 449.32896412, i.e. approximately 44.9329% of the starting amount. The minus sign makes the exponent negative, creating a positive multiplier between zero and one. Store a strictly positive half-life in D19. The equivalent independent exponential model is =A18*EXP(-LN(2)*C18/D19); if D19=4 and elapsed time C18=4, the result is half the original amount. This is a model assumption, not proof of any physical half-life or biological mechanism. EXP; LN.

A common mathematical logistic transformation uses:

=1/(1+EXP(-A21))

For input A21=-2, independently expected output 0.1192029220; with A21=0, 0.5; with A21=2, 0.8807970780. The result lies between 0 and 1 for finite real input in exact mathematics and can help demonstrate a nonlinear mapping from a score to a bounded number. Do not interpret the output as a statistically calibrated probability without a fitted model and validation; this is only the mathematical transform. For very large absolute inputs, floating-point overflow or loss of precision can affect naive implementations; native PlanMaker thresholds were not checked.

If A25 contains a log-transformed value (for example, the independently expected result of =LN(250)), enter =EXP(A25) in B25. The independently expected value is approximately 250 (differences at the smallest floating-point places are possible). This is valid for a natural logarithm, not directly for a log base 10 value. If A25 was computed by LOG(x) with its default base 10, the inverse transform is 10^A25 or POWER(10,A25), not EXP(A25). PlanMaker EXP; LN; LOG with default base 10; POWER.

PlanMaker 2026 English documentation: EXP(Number) computes the e-power; the manual names LN as its inverse. PlanMaker 2024 English documentation: independently shows the same signature and corresponding example. The two pages were checked 2026-10-13, but do not prove edition-specific or mobile parity, identify an introduction date, or constitute a native execution result. 2026 EXP; 2024 EXP.

Regional language and punctuation: SoftMaker documents localized function names and system-custom numeric separators. The one-argument English examples here are not guaranteed to be spelled identically in every language setting.

Microsoft Excel—separate documentation: Microsoft documents EXP(number) as returning e to the required numeric exponent and describes LN as the inverse. This is a strong function-definition similarity, not a verified PlanMaker-to-Excel .xlsx transfer. No Excel execution, formula-round-trip, cross-application coercion, or error-code comparison was performed.

• SoftMaker PlanMaker 2026 — EXP: exact signature, fixed base e, example, LN inverse.
• SoftMaker PlanMaker 2024 — EXP: separately verified version documentation, not introduction history.
• SoftMaker PlanMaker 2026 — LN: documented inverse for positive inputs.
• SoftMaker PlanMaker 2026 — POWER: arbitrary-base exponentiation; differs from EXP.
• SoftMaker PlanMaker 2026 — LOG: chosen logarithm base versus natural log.
• SoftMaker — entering formulas; Edit settings; localized names: formula entry and locale conditions.
• Microsoft Excel — EXP: separate compatibility reference, not PlanMaker behavior evidence.

Vendor and Microsoft documentation checked: 2026-10-13. Claim-level source references above distinguish vendor-documented function definitions from independent mathematical models. All decimal example values were independently computed with Python’s math.exp and math.log and are not PlanMaker worksheet observations. Native PlanMaker executions: 0; native Excel executions: 0; workbook imports/exports: 0; screenshots: 0.