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