The POWER function raises a number to the power you specify.
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.
POWER(Number, Power)
Argument | Data type | Description |
Number | Number | The number to raise to a power. |
Power | Number | The power, or exponent, to raise the number to. |
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).
In Polaris, POWER(0,0)
returns 0.
In the Classic Engine, POWER(0,0)
returns 1.
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.