Related Function:
  • SQRT function

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

Syntax

=POWER(number,power)

Arguments

Argument Description
number The base number. It can be any real number
power The exponent to which the base number is raised

Note: The “^” operator can be used instead of POWER to indicate to what power the base number is to be raised, i.e., =POWER(6,2) is the same as 6^2.

Examples

  A B C
1 Formula Result Notes
2 =POWER(2,3) 8 2 to the 3rd power
3 =POWER(5.5,3)  166.375 5.5 to the 3rd power
4 =POWER(2,0.5) 1.414213562 2 to the power of 0.5
5 =POWER(98.6,3.2) 2401077.222 98.6 to the power of 3.2
6 =POWER(“2”,2) #VALUE! One of the values is a text string

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if either of the supplied arguments can not be interpreted as numeric values