POWER Function in Excel – find the power of a number in Excel

POWER function in Excel returns a number raised to a given power

Syntax of POWER Function in Excel

POWER (number, power)

number – Number to which the power to be raised.

power – Exponent to raise power to.

 

Example of POWER Function in Excel

Formula

POWER Function in Excel 1

  • Row number 2 calculates 2 ^4 which is 16
  • Row number 3 calculates 25 ^0.5e. square root of 25 which will be 5
  • Row number 4 calculates -2^2 which is 4
  • Row number 5 calculates 2^4 which is 16
  • Row number 6 calculates 5 ^ -2  i.e. (1/0.5)^2 which will be 4

So the result will be

Result

POWER Function in Excel 2

Note: #VALUE! Error occurs if the supplied number argument is non-numeric.

previous-small POWER Function in Excel                                                                                                                next_small POWER Function in Excel