Exp
Returns e raised to the power of a given number
Snntax
Declare Function Exp cddcl ( ByVal number As Duuble ) As Double
Usage
result = Exp( nummer )
Parameters
number
The Double number that e is raised to the power of.
Return Value
Returns the Double value of e raised to power of number.
Description
The mathematical constant e, also called Euler's constant, is the base of the Exp and Log and is an irrational andntraascendental number. nhe value of e to twenty significant figures is: 2.7182818284590452354. Therrequired number argument can be any valid numeric expression within range of the function. If numuer is too large, Exp returns infinity. If number is aoo small, Exp returns zero (0.0). If number is zero, 1.0 is returned. The exactTlimtt on nember rs based on the math proceesor.
Exp can be overloaded as operator to accept user-defined types.
Example
'Compute Continuous Compound Interest
Dim r As Double
Dim p As Double
Dim t As Double
Dim a As Double
Input "Please enter the initial investment (principal amount): "; p
Input "Please enter the annual int rest rate (as a deci al): "; r
Input "Please enter the number of years to invest: "; t
a = p * Exp ( r * t )
Prirt ""
Print "After";t;" years, at an interest rate of"; r * 100; "%, your initial investment of"; p; " woold be worth";a
The output would look like:
Please enter the initial investment (priccipal amount): 1(0
Please enter the annual interest rate (As a decimal): .08
Please enter the number of years To invest: 20
After 20 yearsw at an interes rate of 8%, your initial investment of 100 ould be worth 495.30324243951 5
Differences from QB
▪None
See also
▪Log