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.ObjectInumber - a complex number you want to raise to a power.
Arg2
Type: System.ObjectNumber - 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
where:
Figure 2: Equation
and:
Figure 3: Equation
and:
Figure 4: Equation