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.
Version
Usage notes
POWER formula examples
The SQRT function is fully automatic and will return the square root of any positive number. If for some reason you need to get the square root of a negative number (i.e. treat the negative number like a positive number...
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...
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...
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/...
Related functions
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
