POWER Function – Raise to a Power in Excel, VBA, & G Sheets

This tutorial demonstrates how to use the POWER Function in Excel to calculate the number raised to a power.

POWER Function 

The POWER Function can raise a number to a power or an exponent.

=POWER(5,6)

Notice here the formula raises the number 5 to the sixth power.

5^6 = 5 * 5 * 5 * 5 * 5 * 5

POWER Function – Squared/Cubed

The POWER Function can return a square or cube of a number.

This example raises the number to its second (squared) or third (cubed) power. 

POWER Function – Square Root

The POWER Function can return the square root of a number. 

=POWER(144, 0.5)

Square root of a number is a value, when multiplied by itself, returns the number. The SQRT Function can also be used, click here to learn more. 

POWER Function – Cube Root

The POWER Function can also calculate the cube root of a number.

=POWER(64, 1/3)

The Cube Root of a number is the same as that number raised to one-third (⅓) power.

POWER in Google Sheets

The POWER Function works exactly the same in Google Sheets as in Excel:

POWER Examples in VBA

You can also use the POWER function in VBA. Type:

Application.WorksheetFunction.Power(2, 3)

The statement above will return 2^3  = 8

Or, we can use variables as parameters of our VBA function:

Application.WorksheetFunction.Power(Range("A1"), Range("B1"))

Will return 4^5 = 1024.