The Excel IMPOWER function returns a supplied complex number, raised to a given power.
The syntax of the function is:
Where the function arguments are:
| inumber | - | The complex number that you want to raise to a given power. |
| number | - | The power to which the supplied inumber is to be raised. |
The spreadsheets below show five examples of the Excel Impower function:
|
Formulas:
|
Results:
|
Note that, in the above example spreadsheet, the integer 9, used in cell B4, is equal to the complex number 9+0i.
Further details and examples of the Excel Impower function are provided on the Microsoft Office website.
If you get an error from the Excel Impower Function, this is likely to be one of the following:
| #NUM! | - | Occurs if the supplied inumber is not recognised as a complex number. |
| #VALUE! | - |
Occurs if either:
|