Returns the exponential value (base 10) of a numeric expression with a specified number of decimal places.
EXP(number, decimals)
Numeric. Any valid numeric expression.
Numeric constant. The number of decimals to include in the return value.
Numeric.
This function returns the exponential value (base 10) of a numeric expression, which is defined as 10 raised to the nth power. For example, the exponential value of 3 is 10^{3}, or 1000.
Use this function for financial applications requiring complex mathematical calculations. EXP( ) performs the same operation as the exponentiation operator (^), but can be useful in applications that also use the LOG( ) function.
The inverse of an exponent is its logarithm, so EXP( ) is the opposite of the LOG( ) function.
Example | Return value |
---|---|
EXP(3, 2) |
1000.00 |
EXP(4.86, 6) |
72443.596007 |
To create a field that is the cube root of the field X to two decimal places, specify:
EXP(LOG(X, 6) / 3, 2)
You can determine the nth root by dividing the log of the value by n and taking the exponential of the result.