WorksheetFunction.ImSqrt Method

Returns the square root of a complex number in x + yi or x + yj text format.

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

Syntax

'Declaration
Function ImSqrt ( _
    Arg1 As Object _
) As String
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim returnValue As String

returnValue = instance.ImSqrt(Arg1)

string ImSqrt(
    Object Arg1
)

Parameters

• Arg1
  Type: System.Object

  Inumber - a complex number for which you want the square root.

Return Value

Type: System.String

Remarks

Use Complex(Object, Object, Object) to convert real and imaginary coefficients into a complex number. The square root of a complex number is:

Figure 1: Square root of a complex number

where:

Figure 2: Equation

and:

Figure 3: Equation

and:

Figure 4: Equation

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace