Expand Minimize
This topic has not yet been rated - Rate this topic

WorksheetFunction.ImPower Method (Excel)

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: Ff192962.awfimpw1_ZA06051164(en-us,office.14).gifwhere: Ff192962.awfimpw2_ZA06051165(en-us,office.14).gifand: Ff192962.awfimpw3_ZA06051166(en-us,office.14).gifand: Ff192962.awfimar3_ZA06051155(en-us,office.14).gif

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.