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 numeric values.
Note that the Excel Power function is the same as using the power operator ^.
I.e.
The following spreadsheet shows three simple examples of the Excel Power function.
|
Formulas:
|
Results:
|
For further examples of the Excel Power function, see 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 non-numeric. |