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. |
Example
Sample formulas
Sample formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Raise Euler's number (e) to the power of a specified value. | =EXP(0) |
This formula works in the following manner:
This formula returns 1. |
| Raise Euler's number (e) to the power of a value in a cell. | =EXP(B1) |
This formula works in the following manner:
For this data set, this formula returns 2.71828182845905. |
| Raise Euler's number (e) to the power of a calculated value. | =EXP(B2-A2) |
This formula works in the following manner:
For this data set, this formula returns 3.77513E-11 (a very small number in scientific notation). |
Notes
- Wildcards don't work with this function.
Related functions
ABS
LN
MOD
N
POWER
PRODUCT
SIGN
SQRT
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT