Excel: Exp Function

In Excel, the Exp function returns e raised to the nth power, where e = 2.71828183.

The syntax for the Exp function is:

Exp( number )

number is the power to raise e to.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Exp(A1) would return 20.08553692

=Exp(A2) would return 22.19795128

=Exp(A3) would return 0.049787068

=Exp(-4.5) would return 0.011108997

VBA Code

The Exp function can also be used in VBA code. For example:

Dim LNumber As Double

LNumber = Exp(3)

In this example, the variable called LNumber would now contain the value of 20.08553692.