Exponential Method
The Exponential method returns the value e raised to the power of the value that you specify in the number argument. The value e is the base of natural logarithms. The constant e is approximately 2.718282. For information about how this method handles the data type, see How Some Math Methods Handle the Data Type.
Format
Exp(number)
The following table describes the arguments that you can use with this method.
Argument | Description |
---|---|
number |
The exponent value of e. |
Example
The following example estimates the value of a factorial of a number that the user enters:
Sub Button_Click
Dim x as Single
Dim msgtext, PI
Dim factorial as Double
PI = 3.14159
i: x = 55
If x< = 0 then
Exit Sub
ElseIf x>88 then
Goto i
End If
factorial = Sqr(2 * PI * x) * (x^x/Exp(x))
msgtext = "The estimated factorial is: " & Format _
(factorial, "Scientific")
End Sub
A factorial is the product of a number and each integer between it and the number 1. For example, 5 factorial, or 5!, is the product of 5*4*3*2*1, or the value 120. An exclamation point (!) can specify a factorial.