WorksheetFunction.ImPower Method

Excel Developer Reference

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:

    Equation

    where:

    Equation

    and:

    Equation

    and:

    Equation

See Also