EXP in WPS Spreadsheet: Calculate Powers of e and Exponential Models

• Introduced: documented by 2019-06-19 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; no numeric release is stated. This is documentation evidence, not an installed-build guarantee.
• Scope: exact supported builds remain unverified. The Windows lesson does not establish equivalent availability in other WPS clients.
• Checked: October 14, 2026 against function-specific documentation. Examples were independently calculated; no native WPS test was performed.

=EXP(number)

The official WPS lesson describes e as approximately 2.71828182845904 and identifies EXP as the inverse of the natural-log function LN. For another base, use the exponent operator or the appropriate POWER calculation.

The examples use finite numeric values, English names and comma separators where nested formulas need them. Approximate results are displayed to nine decimal places without claiming a native WPS precision test.

Enter -2, -1, 0, 1, 2 in A2:A6 and fill down:

=EXP(A2)

Independent mathematical expectations are approximately 0.135335283, 0.367879441, 1, 2.718281828 and 7.389056099. A negative exponent produces a positive reciprocal, not a negative result.

For the ordinary real-valued model, e to the zero power equals one. This is an independent boundary expectation consistent with the documented operation, not a newly observed native application result.

=EXP(3)
=3^2
=2^3

Expected results are approximately 20.085536923, 9 and 8. The first always uses e as its base. Changing the argument to three does not ask for three squared or two cubed.

Write the model’s base beside the formula when teaching or handing off a workbook. A correctly evaluated expression can still be the wrong expression for the intended quantity.

Suppose a fictional quantity starts at 100 and follows the specified model 100*EXP(-0.3*t), where t is measured in a fixed time unit. Put t values 0, 1, 2, 5 in C2:C5:

=100*EXP(-0.3*C2)

Expected quantities are approximately 100, 74.081822068, 54.881163609 and 22.313016015. The coefficient 0.3 is per time unit, making its product with t dimensionless.

This is a supplied mathematical model, not a claim that real observations necessarily follow exponential decay. Changing time units without adjusting the coefficient changes the model. Preserve the starting amount and rate as explicit inputs if they need to be edited.

=EXP(0.2)*EXP(0.4)
=EXP(0.2+0.4)

Both independently expected results are approximately 1.822118800. The identity is e^a times e^b equals e^(a+b); adding the two EXP results would be a different operation.

Similarly, =EXP(-1)*EXP(1) has mathematical expectation 1. These are useful small controls, but they do not certify identical last bits when different native floating-point paths are used.

For positive value 7, =EXP(LN(7)) has independently expected result 7. For exponent -0.4, =LN(EXP(-0.4)) has expected result -0.4 in the ordinary finite mathematical model.

The inverse relationship does not remove numeric limits. Very large or small exponents can challenge a finite implementation, and an underflowed or rounded intermediate is not the exact real number used in the algebraic identity.

The dated WPS lesson does not give a full overflow, underflow, text-conversion or error-code matrix. Exact current-build boundaries remain unverified. Do not copy another application’s maximum exponent and call it a WPS limit.

If a result has the wrong sign, inspect the model: ordinary EXP outputs are positive even for negative exponents. If the magnitude is wrong, check that the exponent is dimensionless and that parentheses include every intended factor. Preserve the raw numeric result and round only at the reporting stage.

• WPS Academy: EXP lesson, 2019-06-19 (Chinese; Windows Personal scope).
• Editorial testing standards.

The cited WPS product lesson was read directly. Worked outputs are independent expectations, not captured native results or proof of support across all current WPS clients.