WorksheetFunction.ImPower Method (Excel)
Published: July 16, 2012
Returns a complex number in x + yi or x + yj text format raised to a power.
expression .ImPower(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
|
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
|
Arg1 |
Required |
Variant |
Inumber - a complex number you want to raise to a power. |
|
Arg2 |
Required |
Variant |
Number - the power to which you want to raise the complex number. |
Return Value
String
-
Use COMPLEX to convert real and imaginary coefficients into a complex number.
-
If number is nonnumeric, IMPOWER returns the #VALUE! error value.
-
Number can be an integer, fractional, or negative.
-
A complex number raised to a power is calculated as follows:
where: 
and: 
and: 
