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
Download Example Workbook

Download the example workbook

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

POWER Function 

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

=POWER(5,6)

POWER 01

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.

POWER 04

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)

POWER 02

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)

POWER 03

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 Google Function

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:

Vba POWER function

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

Will return 4^5 = 1024.

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions