1. Calculation functions
2. All Functions
3. Numeric functions
4. POWER

The POWER function raises a number to the power you specify.

This function is the inverse of the LOG function.

For example, if the formula LOG(a, b) gives a result of c, the formula POWER(b, c) gives a result of a.

Syntax

POWER(Number, Power)

Arguments

 Argument Data type Description Number Number The number to raise to a power. Power Number The power, or exponent, to raise the number to.

Constraints

Cannot return root of negative numbers

The POWER function can be used to calculate the root of a positive number by using a fraction for the Power argument. For example using 1/2 or 1/3 for the Power argument returns the square root and cube root respectively. However, if you attempt to return the root of a negative number, the POWER function returns a result of NaN (Not a Number).

Calculation engine functionality differences

In Polaris, POWER(0,0) returns 0.

In the Classic Engine, POWER(0,0) returns 1.

POWER

Examples

 Formula Description Result POWER(2, 4) This formula raises two to the power of four. 16 POWER(9, 9) This formula raises nine to the power of nine. 387,420,489