WorksheetFunction.ImPower Method

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function ImPower ( _
    Arg1 As Object, _
    Arg2 As Object _
) As String
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim Arg2 As Object
Dim returnValue As String

returnValue = instance.ImPower(Arg1, Arg2)
string ImPower(
    Object Arg1,
    Object Arg2
)

Parameters

  • Arg1
    Type: System.Object

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

  • Arg2
    Type: System.Object

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

Return Value

Type: System.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

Equation complex number raised to a power

where:

Figure 2: Equation

Equation

and:

Figure 3: Equation

Equation

and:

Figure 4: Equation

Equation

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace