|
The Excel IMPOWER Function
Basic Description
The Excel IMPOWER function returns a supplied complex number, raised to a given power.
The syntax of the function is :
IMPOWER( inumber, number )
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
|
Excel Impower Function Examples
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.
|
Formulas:
| |
A |
| 1 |
=IMPOWER( "2-i", 2 ) |
| 2 |
=IMPOWER( "2-i", 3 ) |
| 3 |
=IMPOWER( "5+2i", 2 ) |
| 4 |
=IMPOWER( 9, 0.5 ) |
| 5 |
=IMPOWER( "2+4i", -2 ) |
|
Results:
| |
A |
| 1 |
3-4i |
| 2 |
2-11i |
| 3 |
21+20i |
| 4 |
3 |
| 5 |
-0.03-0.04i |
|
More details and examples of the Excel Impower function are provided on the
Microsoft Office website.
Impower Function Errors
If you get an error from the Excel Impower Function, this is likely to be one of the following:
Common Errors
|
#NUM!
|
-
|
Occurs if the supplied inumber argument is not recognised as a complex number
|
|
#VALUE!
|
-
|
Occurs if the supplied number argument non-numeric
|
|
#NAME?
|
-
|
Occurs when Analysis ToolPak add-in is not enabled in your Excel.
You will need to enable the add-in if you want to use the Excel engineering functions.
To do this in Excel 2003 :
- From the Tools drop-down menu, select the option Add-Ins ...
- An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak and click OK
To do this in Excel 2007 or Excel 2010 :
- Click the Microsoft button on the top left of your spreadsheet and select
the Excel Options button
- From the menu on the left hand side, select Add-Ins
- In the 'Manage:' box, select Excel Add-ins and click Go...
- An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak
and click OK
|
|
