WorksheetFunction.ImSqrt(Object) Method

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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

public:
 System::String ^ ImSqrt(System::Object ^ Arg1);

public string ImSqrt (object Arg1);

Public Function ImSqrt (Arg1 As Object) As String

Parameters

Arg1

Object

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

Returns

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