ID EN
…
#Math

POWER

Excel Functions

Raise a number to a power

Syntax

EXCEL 
=POWER(number, power)

Arguments

Parameter Description
number Number to raise to a power.
power Power to raise number to (the exponent).

Return Value

Number raised to power

Details

The POWER function returns a number raised to a given power. POWER is an alternative to the exponent operator (^) in a math equation. The POWER function takes two arguments: number and power. Number should be a numeric value, provided as a hardcoded constant or as a cell reference. The power argument functions as the exponent, indicating the power to which number should be raised. To raise 2 to the 3rd power, you can use POWER like this: To raise 2 to the 8th power: To cube the value in cell A1:

Examples

Examples

To raise 2 to the 3rd power, you can use POWER like this:

EXCEL 
=POWER(2,3) // returns 8
Examples

To raise 2 to the 8th power:

EXCEL 
=POWER(2,8) // returns 256
Examples

To cube the value in cell A1:

EXCEL 
=POWER(A1,3) // cube A1
Fractional exponents

To use the power function with a fractional exponent, enter the fraction directly as the power argument:

EXCEL 
=POWER(27,1/3) // returns 3
=POWER(81,1/4) // returns 3
=POWER(256,1/8) // returns 2
Exponent operator

In Excel, exponentiation can also be handled with the exponent (^) operator, so:

EXCEL 
=2^2=POWER(2,2)=4
=2^3=POWER(2,3)=8
=2^4=POWER(2,4)=16

See Also

SQRT LOG