Exp Function

Returns a Double specifying e (the base of natural logarithms) raised to a power.


Exp( number )

The required numberargument is a Double or any valid numeric expression.


If the value of number exceeds 709.782712893, an error occurs. The constante is approximately 2.718282.

Note:  The Exp function complements the action of the Log function and is sometimes referred to as the antilogarithm.


Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

This example uses the Exp function to return e raised to a power.

Dim MyAngle, MyHSin
' Define angle in radians.
MyAngle = 1.3
' Calculate hyperbolic sine.
MyHSin = (Exp(MyAngle) - Exp(-1 * MyAngle)) / 2

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!