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.

Download PDF

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)

• Video Tutorial: Power function in excel

further reading:

• POWER function - Microsoft Support

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).