Expand Minimize

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: awfimpw1_ZA06051164where: awfimpw2_ZA06051165and: awfimpw3_ZA06051166and: awfimar3_ZA06051155

Community Additions

ADD
Show:
© 2014 Microsoft