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 values returned from other functions, or as references to cells containing numbers.
Note that the Excel Power function is the same as using the power operator ^.
I.e.
The following spreadsheet shows examples of the Excel Power function.
Formulas:
 Results:

Further examples of the Excel Power function can be found on the Microsoft Office website.
If you get an error from the Excel Power Function, this is most likely to be the #VALUE! error:
#VALUE!    Occurs if either of the supplied arguments are nonnumeric. 