WorksheetFunction.ImPower Method (Excel)
Returns a complex number in x + yi or x + yj text format raised to a power.
Syntax
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
Remarks
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:
.gif "Ff192962.awfimpw1_ZA06051164(en-us,office.14).gif")
where: .gif "Ff192962.awfimpw2_ZA06051165(en-us,office.14).gif")
and: .gif "Ff192962.awfimpw3_ZA06051166(en-us,office.14).gif")
and: .gif "Ff192962.awfimar3_ZA06051155(en-us,office.14).gif")