How to Use POWER Function in Excel | Excel Formula Guide
Learn how to use the POWER function in Excel to calculate exponents. Includes syntax, practical examples, and tips for advanced mathematical formulas.
POWER
Returns the result of a number raised to a power.
Syntax
POWER(number, power)The POWER function syntax has the following arguments:
Number Required. The base number. It can be any real number. Power Required. The exponent to which the base number is raised.
=POWER(5,2)further reading:
Exercise 6: Power and Square Root
- In cell A1, enter a number, e.g., 4.
- In cell B1, calculate the square of the number using the formula
=A1^2. - In cell B2, calculate the square root of the number using the formula
=SQRT(A1).