EXP computes the natural exponential e^x. For example, =EXP(1) should produce approximately 2.718281828, and =EXP(0) should produce 1. Those are mathematical expectations based on the official function definition; this guide does not claim Calligra was run.

=EXP(x)

x is required and numeric. It is the exponent, not the base and not a percentage typed as a whole number unless that is what you intend. There is no optional argument and no default. KDE’s EXP entry documents a floating-point return value and illustrates positive and negative exponents, e.g. EXP(-9) being a very small positive quantity. If you need a different base, an exponentiation expression such as 2^B2 or an appropriate power function is conceptually different from EXP(B2).

Evidence and scope: The official KDE function handbook and the source registry pinned to Calligra 26.08.2 (released 2026-10-08) were consulted on 2026-10-11. The registry confirms inclusion in the shipped source module, not that every operating-system package has the same functions enabled. KDE’s Calligra Sheets release page currently lists 26.08.2. The main documented installation environment is Linux, using a distribution package or Flatpak; Windows availability was not established for this review. These examples have not been entered or run in a native Calligra Sheets application.

Formula-entry conventions: Start a cell formula with =. Calligra’s English handbook writes multiple parameters with semicolons, as in IF(test;true_value;false_value); none of this function’s own calls takes multiple arguments except where explicitly shown in a composite formula. Locale-dependent decimal symbols and formula separators can differ: confirm them in the installed Insert → Function interface. Numeric constants in tables below use a decimal point for the English-locale example.

Add headings to A1:C1 and the numeric exponents below. In C2 enter =EXP(B2) and fill down through C6.

These are independently calculated and rounded to six decimal places. The original formula returns a floating-point number, and your spreadsheet may show a different number of digits.

Steps: Enter the labels and exponents exactly, set C2 to =EXP(B2), copy down, and format C as a number. The formula in C4 uses the exponent -1; mathematically, e^-1 = 1/e, which is approximately 0.367879. A negative exponent is valid here; it expresses decay rather than an error.

For a continuously compounded amount, use the model future value = principal × exp(rate × years). Populate these cells:

In H2 enter:

=E2*EXP(F2*G2)

Expected H2 ≈ 1161.834243, because 1000 × e^0.15 ≈ 1161.834243. Enter 0.05, not 5, for a five-percent rate; EXP(5*3) would produce an entirely different and very large growth factor. This is a mathematical example, not financial advice or native validation.

Inverse check and simple validation

A useful algebra check is:

=LN(EXP(B3))

With B3=1, the expected result is 1, within floating-point rounding. Likewise, =EXP(LN(4)) is mathematically expected to return 4. The inverse only works in the real domain when the LN argument is positive. To avoid unexpectedly large exponentials, a simple policy example is:

=IF(B2>10;"Check exponent";EXP(B2))

For B2=12, the expected output is the warning; for B2=2, the expected numeric output is about 7.389056. See the existing IF guide for the conditional structure. This safety threshold is user-defined, not a documented Calligra hard limit.

• Confusing percentage points with decimals: For 5%, enter 0.05. A value of 5 means a 500% exponent per unit, not a five-percent rate.
• Expecting base 10 or base 2: EXP always uses base e. Use another expression or the appropriate power function for other bases.
• Huge x: Very large positive exponents can exceed finite floating-point representation; very negative exponents can underflow toward zero. The KDE handbook does not specify a universal numeric threshold or error code. Avoid inventing one for your installation.
• Text rather than numbers: Verify that imported numbers are numeric cells; check formulas, separators, leading equals sign, and references.
• Apparent rounding mismatch: Set similar numeric formatting before comparing answers. Floating-point inverse checks can differ at the final digit.
• Completely wrong output: Check that the exponent cell is B2, not an adjacent date/currency/percentage-display cell.

Calligra, Microsoft Excel and LibreOffice Calc document a one-argument exponential function EXP(x) with base e. Excel’s official EXP page explicitly describes the inverse relationship with LN. LibreOffice Calc’s mathematical-functions reference supplies compatible mathematical intent. Differences may arise from calculation precision, error codes, regional decimal notation and formula separators, not from the stated mathematical definition. Calligra’s English handbook shows semicolons in multi-argument formulas such as IF; an Excel formula with commas should not be pasted unchanged without checking locale.

EXP and LN are inverse functions for their appropriate mathematical domains; POWER uses a chosen base. Other new Calligra tutorials may be awaiting owner review, so only the already-existing IF tutorial is linked here as a live-site route.

• KDE Calligra Sheets EXP function: exact syntax, argument and samples, accessed 2026-10-11.
• Pinned 26.08.2 EXP source registration, evidence of inclusion in source, not execution.
• KDE Calligra Sheets current release page, checked 2026-10-11, lists 26.08.2 on 2026-10-08.
• Microsoft’s EXP reference and LibreOffice mathematical functions, accessed 2026-10-11 for portability notes.

• Calligra Sheets — function documentation
• KDE function handbook
• LibreOffice Calc’s mathematical-functions reference
• Pinned 26.08.2 EXP source registration

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Calligra Sheets.

• No genuine Calligra Sheets screenshots are included; this guide does not use mock application images.