The Excel POWER Function

Related Function:
SQRT function

Function Description

The Excel Power function calculates a given number, raised to a supplied power.

The syntax of the function is:

POWER( number, power )

where the number and power arguments are numeric values.

Note that the Excel Power function is the same as using the power operator ^.


POWER( 4, 2 ) is the same as 4^2.

Excel Power Function Examples

The following spreadsheet shows three simple examples of the Excel Power function.

  A B C
1 =POWER( 2, 3 )
2 5.5 3 =POWER( A2, B2 )
3 2 0.5 =POWER( A3, B3 )
  A B C
1 8
2 5.5 3 166.375
3 2 0.5 1.414213562

For further examples of the Excel Power function, see the Microsoft Office website.

Power Function Error

If you get an error from the Excel Power Function, this is most likely to be the #VALUE! error:

Common Errors
#VALUE! - Occurs if either of the supplied arguments are non-numeric.