Description
Use this function to return the result of the constant e raised to the power of a number. Supported in Chains.
Definition of "e"
e (Euler's number) is a irrational numeric constant whose value is approximately 2.71828182845904.
This function models exponential growth and the output of the function at a given point is proportional to the rate of change of the function at that point. The function that is the inverse of the exponential function is the LN (natural logarithm) function, which represents exponential decay.
For a more detailed explanation see wumbo.net.
Syntax
EXP(number)
Inputs
This function has the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
number |
Yes | The number to be acted on. | A cell reference, a number, or a formula which results in either of these. |
Examples
Sample data
| A | B | ||
|---|---|---|---|
| 1 | 5 |
1 |
|
| 2 | 35 |
11 |
|
| 3 | 0.05 |
12 |
Sample formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Raise Euler's number (e) to the power of a specified value. | =EXP(0) |
Any number raised to the power 0 is 1, so this returns 1. |
| Raise Euler's number (e) to the power of a value in a cell. | =EXP(B1) |
B1 contains 1, so this calculates e1. Result: 2.71828182845905 |
| Raise Euler's number (e) to the power of a calculated value. | =EXP(B2-A2) |
B2-A2 is calculated first (11 − 35 = -24), then EXP raises e to that power. Result: 3.77513E-11 (a very small number, shown in scientific notation) |
| Calculate continuous compound growth using a rate and a number of periods. | =1000*EXP(A3*B3) |
Models $1000 growing continuously at a 5% rate (A3) over 12 periods (B3), using the continuous-compounding formula P×ert. Result: 1822.12 |
Notes
- Wildcards don't work with this function.