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

ArgumentData typeDescription
NumberNumberThe number to raise to a power.
PowerNumberThe 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).

Excel equivalent

POWER

Examples

FormulaDescriptionResult
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