Exceljet

Quick, clean, and to the point

Excel POWER Function

Excel POWER function
Summary 

The Excel POWER function returns a number to a given power. The POWER function works like an exponent in a standard math equation.

Purpose 
Raise a number to a power
Return value 
Number raised to power
Syntax 
=POWER (number, power)
Arguments 
  • number - Number to raise to a power.
  • power - Power to raise number to (the exponent).
Version 
Usage notes 

The POWER function can be used to raise a number to a given power. The POWER function works like an exponent in a standard math equation.

Examples

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

=POWER(2,3) // returns 8

To raise 2 to the 8th power:

=POWER(2,8) // returns 256

In Excel, exponentiation is handled with the caret (^) operator, so:

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

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.