The POWER function raises a number to the power you specify.
POWER
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.
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.
Excel equivalent
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 |
Disclaimer
We update Anapedia content regularly to provide the most up-to-date instructions.