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

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