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

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 9, 2023

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.

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.

### Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!