Back to Function Index
EXP()
Overview
EXP() calculates the exponential function, raising the mathematical constant e (approximately 2.71828) to the power of the specified number. This function is commonly used in mathematical calculations, statistical analysis, and scientific computations.
Function Format
EXP(number)
Return Value
EXP() returns a numeric value
Examples
EXP(-1) = 0.3679 (e^-1)
EXP(0) = 1.0000 (e^0)
EXP(1) = 2.7183 (e^1)
EXP(3) = 20.0855 (e^3)
EXP(10) = 22026.4658 (e^10)
EXP(0.5) = 1.6487 (e^0.5)
EXP(-0.5) = 0.6065 (e^-0.5)
Notes
The function uses the mathematical constant e (approximately 2.71828) as its base. Common use cases include:
Exponential growth calculations Statistical analysis Scientific computations Financial calculations Natural logarithm calculations (inverse of EXP) Important mathematical properties:
EXP(0) = 1 EXP(1) = e EXP(-x) = 1/EXP(x) EXP(x + y) = EXP(x) * EXP(y) The function can be used with any numeric value, including:
Positive numbers Negative numbers Zero Decimal numbers This function is the inverse of the natural logarithm function (LN). For very large positive numbers, the result may exceed the maximum value that can be represented. For very large negative numbers, the result will be very close to zero.
See Also
