Excel Tutorial

Excel POWER Function

The Excel POWER function returns the number raised to a given power. The POWER function is an alternative to the exponent operator (^).

The POWER function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function in Excel. As a worksheet function, the POWER function can be used as part of a formula in a worksheet cell.

Syntax

POWER(number, power)

Parameters

`number`	`Required.` Specify the base number. It can be any real number.
`power`	`Required.` Specify the exponent to which the base number is raised.

Return Value

Returns the number raised to a given power.

Notes

If any of the argument is a non-numeric value, POWER returns #VALUE! error.
If both of the arguments are 0, POWER returns #NUM! error.

Example: Using as Worksheet Function

The example below shows how to use the POWER function as worksheet function.

Based on the Excel spreadsheet above, the output of the following worksheet formula will be:

=POWER(C5, D5)
Result: 8

=POWER(C6, D6)
Result: 0.125

=POWER(C7, D7)
Result: 1.414213562

=POWER(C8, D8)
Result: 0.707106781

=POWER(C9, D9)
Result: 4

=POWER(C10, D10)
Result: 5

❮ Excel Functions