WorksheetFunction.ImPower(Object, Object) Method

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Returns a complex number in x + yi or x + yj text format raised to a power.

public:
 System::String ^ ImPower(System::Object ^ Arg1, System::Object ^ Arg2);

public string ImPower (object Arg1, object Arg2);

Public Function ImPower (Arg1 As Object, Arg2 As Object) As String

Parameters

Arg1

Object

Inumber - a complex number you want to raise to a power.

Arg2

Object

Number - the power to which you want to raise the complex number.

Returns

String

Remarks

Use Complex(Object, Object, Object) 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:

Figure 1: Equation complex number raised to a power

where:

Figure 2: Equation

and:

Figure 3: Equation

and:

Figure 4: Equation