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 initial complex number that you want to raise to a power|
|number||-||The power to which the supplied complex number is to be raised|
In the example below, the Excel Impower function is used to calculate several complex numbers raised to different powers.
The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
More 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 argument is not recognised as a complex number|
Occurs when Analysis ToolPak add-in is not enabled in your Excel.