The Excel POWER Function

Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Power-Function Search this site: Custom Search

Related Function:  SQRT function

Basic Description

The Excel Power function calculates a given number, raised to a supplied power.

The syntax of the function is :

where the number and power arguments are numerical values.

These can be supplied to the function either directly, as a value returned from another function, or as a reference to a cell containing a number.

Note that the Excel Power function is the same as using the power operator ^

ie.

Excel Power Function Examples

The following spreadsheet shows examples of the Excel Power function. The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Formulas:

Results:

Further examples of the Excel Power function can be found on the Microsoft Office website.

Power Function Errors

If you get an error from the Excel Power Function, this is most likely to be the #VALUE! error: