EXP computes e raised to a chosen exponent. It is useful for continuous-growth models and reversing a natural logarithm. It does not mean “raise an arbitrary number to a power”; use POWER for that operation.

Official Apple syntax: EXP(exponent). This guide uses the Apple Functions Help 15.4 entry, inspected on 2026-10-11. The documentation version identifies this help edition; it does not prove which Apple Numbers release first supported the function. The examples are mathematically expected results, not recorded runs from the Numbers application.

A monitoring model projects a quantity that changes at a continuous proportional rate. Before building the model, test EXP on small known exponents. If your goal is to compare values in a large table, first check the data type and the mathematical transformation you need. Logarithms change scale and do not simply reformat numbers; the exponential function reverses the natural-log transformation for valid inputs.

=EXP(exponent)

Apple requires a numeric exponent. The EXP result is mathematically positive for any real exponent, but sufficiently extreme exponents may exceed the engine’s numeric limits; the exact threshold was not tested in Numbers. Apple’s official page defines these limits and any defaults: function reference. For input types and cross-table references, consult Apple’s value-type reference.

Decimal separators and locales: Apple’s English examples separate arguments with commas and use a decimal point in numbers. Apple says to use semicolons between arguments if your system uses a decimal comma. For example, a decimal-comma locale may enter 0,5 as a numeric input where the English examples use 0.5. This function has only one argument, so no argument separator is used in the basic formula. Nested two-argument functions may require semicolons when the decimal separator is a comma. Use the formula editor to insert references. See Apple’s official functions overview.

1. Open a new Numbers document and make one table called Logarithm Lab. Mark row 1 as a header.
2. Put Input in B1; put Result in C1. Copy the numbers shown below into B2:B7 as actual numbers, not text.
3. Enter the formula in C2, then fill down through C7; the B-row reference changes automatically as you fill. Format the result cells to show six decimal places for comparison.
4. Compare the results to the independent expectations. Small final-digit differences are possible when software uses floating-point arithmetic; integer-looking results below are mathematical exact values for the chosen inputs, not native Numbers screenshots.

These displayed values were calculated independently using Python’s math functions, then rounded to six decimal places for display. Do not interpret them as six-decimal internal precision in Numbers. Values may display differently under General, Scientific, or region-specific number formats.

If your result is in another table: selecting the input cell while editing the formula lets Numbers insert a qualified reference, such as Logarithm Lab::B2; do not assume unqualified B2 refers to the intended table in a multi-table document. See Apple’s reference-value examples. Relative references normally adjust when filled; confirm formula references after moving or copying cells.

Continuous-growth illustration

With B12 = 1000 (starting amount), C12 = 0.05 (annual continuous rate) and D12 = 3 (years), =B12*EXP(C12*D12) has the mathematically expected value 1161.834243 when shown to six decimals. It models continuous compounding; it is not a claim about actual bank interest or investments.

Reverse a natural-log transform

If B13 contains 4, =EXP(LN(B13)) is mathematically 4. Floating-point computation may give an approximation rather than an exactly identical stored value. This use requires a positive B13 because LN is not defined for zero or negative real numbers.

Convert a continuously compounded rate

If B14 contains a continuous annual rate of 0.06, =EXP(B14)-1 yields approximately 0.061837, or 6.1837%, for a one-year effective change under that model. A 100% percentage format can display the result as a percentage without multiplying the stored number by 100.

• Unexpected 1: Check whether the exponent is 0: EXP(0) is exactly 1 mathematically.
• Need 2 to a power, not e: Use POWER(2,3) for 8, not EXP(3); EXP(3) is approximately 20.085537.
• Model grows too quickly: Check whether the rate is entered as 0.05 for 5%, rather than as 5.
• Unexpected error from imported values: confirm the inputs are numeric and satisfy the documented domain. A string that looks like "100" is not the same as a confirmed numeric value. Apple distinguishes number values from string values in its value-type glossary.
• A formula gives a surprising output after copying: inspect its relative cell addresses and table qualification. When the formula refers to another table, Numbers uses :: separators, as described in Apple’s documentation.
• Displayed digits differ slightly from the expected table: the six-decimal columns are rounded for readability. Apple’s functions may compute using floating-point arithmetic, and even mathematical inverses can disagree in their low-order digits.
• Formula rejected in a non-English locale: verify the region’s decimal symbol and argument separator. Use Numbers’ formula editor rather than assuming pasted Excel or English syntax is universally accepted.
• Extreme inputs or app-specific errors: this guide does not assert a particular error-code spelling, overflow threshold, coercion policy or first-supported release because no native Numbers installation was available for testing.

Excel also documents EXP(number) to compute e raised to the supplied number. The numeric operation is equivalent in the ordinary real-number examples here, although formatting, platform availability and precision limits are not certified across versions. Microsoft documents the Excel counterpart in its official EXP reference, checked 2026-10-11. This confirms the ordinary mathematical operation, not identical handling of every empty cell, invalid string, floating-point boundary or user locale.

This batch has not executed the formulas in Google Sheets or verified Sheets-specific coercion, error strings, or platform/version behavior. Before copying a large production workbook, test representative values in the destination app and verify the imported cell types; similarly named formulas are not a guarantee of full parity.

• EXP

• Apple Numbers — function documentation
• Apple’s value-type reference
• Apple’s official functions overview
• LN
• LOG
• LOG10

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

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