EXP( ) function

Returns the exponential value (base 10) of a numeric expression with a specified number of decimal places.

Syntax

EXP(number, decimals)

Parameters

number

Numeric. Any valid numeric expression.

decimals

Numeric constant. The number of decimals to include in the return value.

Output

Numeric.

Remarks

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 103, 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.

Examples

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)
Tip

You can determine the nth root by dividing the log of the value by n and taking the exponential of the result.

Related reference
LOG( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback