Documentation/Calc Functions/EXP
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
EXP
Category:
Mathematical
Summary:
Calculates the mathematical constant e (Euler's number) raised to the power of a specified number. This is commonly known as the exponential function.
Syntax:
EXP(Number)
Returns:
Returns a positive real number that is e raised to the power of the specified number.
Arguments:
Number is a real number, or a reference to the cell containing that number, that is the power to which e is to be raised.
- If Number is non-numeric, then EXP returns a #VALUE! error.
Additional details:
- The mathematical constant e has a value of approximately 2.71828182845904.
- The formula for the exponential function is:
[math]\displaystyle{ \text{EXP}(x)~=~1+\frac{x}{1!}+\frac{x^2}{2!}+\frac{x^3}{3!}+\frac{x^4}{4!}+... }[/math]
- The figure below illustrates the EXP function:
Examples:
| Formula | Description | Returns |
|---|---|---|
| =EXP(−6) | e raised to the power of -6. | 0.002478752176666 |
| =EXP(D1) where cell D1 contains the number 0. | e raised to the power of 0. | 1 |
| =EXP(1) | e raised to the power of 1. | 2.71828182845904 |
| =EXP(8) | e raised to the power of 8. | 2,980.95798704173 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
EXP