Jump to content

Documentation/Calc Functions/EXP

From The Document Foundation Wiki


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:
    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:

LN

LOG

ODF standard:

Section 6.16.31, part 2

Related (or similar) Excel functions:

EXP