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:
POWER formula examples
The cube root of a number can be calculated manually with the exponentiation operator (^) or with the POWER function.
Manually with ^
The cube root of a number can be calculated manually by raising a number to the (1/...
In geometry, the formula for calculating the surface area of a right cone is:
The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is represented in a formula...
In geometry, a sphere is defined as the set of points that are all the same distance (r) from a given point in a three-dimensional space. The formula for calculating the surface area of a sphere is:
The Greek...
This example shows one way to calculate BMI (Body Mass Index) in Excel. The standard BMI formula is:
BMI = weight (kg) / height (m)2
The approach used here is to first convert height in inches and feet to meters, and...
In geometry, a sphere is defined as the set of points that are all the same distance (r) from a given point in a three-dimensional space. The formula for calculating the volume of a sphere is:
Where r represents...
In geometry, the formula for calculating the volume of a cylinder is:
The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is represented in a formula with...
In geometry, the formula for calculating the volume of a cone is:
The formula for calculating the volume of a cone is based on the formula for calculating the volume of a pyramid. Since the base of a cone is a...
In geometry, the standard formula for calculating the surface area of a cylinder is:
In essence, this formula first calculates the area of the side of the cylinder, based on the circumference of the circle times...
By definition, the nth root of a number can be calculated by raising that number to the power of 1/n. Exponents are entered using the exponentiation operator (^), with a number on the left and power on the right. So, in...
The SQRT function is fully automatic and will return the square root of any positive number. For example, to get the square root of 25:
=SQRT(25) // returns 5
If you give SQRT a negative number, it will return a #NUM...
In geometry, the area enclosed by a circle with radius (r) is defined by the following formula: πr2
The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is...
Related functions
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.
