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 - Exponent to raise power to.
Usage notes
POWER formula examples
To get the cube root of a number, you can use the caret(^) operator with 1/3 as the exponent in a simple formula. In the example shown, the formula in D5 is:
=B5^(1/C5)
How this function works
By definition, the nth...
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...
To get the square root of a number, you can use the SQRT function. In the example shown, the formula in C5 is:
=SQRT(B5)
How this function works
The SQRT function is fully automatic and will return the square root...
To get the cube root of a number, you can use the caret(^) operator with 1/3 as the exponent in a simple formula. In the example shown, the formula in C5 is:
=B5^(1/3)
How this function works
The cube root of a...
Related functions
