This documentation is archived and is not being maintained.

WorksheetFunction.ImSqrt Method

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

Syntax

expression.ImSqrt(Arg1)

expression   A variable that represents a WorksheetFunction object.

Parameters

NameRequired/OptionalData TypeDescription
Arg1RequiredVariantInumber - a complex number for which you want the square root.

Return Value
String

Remarks

  • Use COMPLEX to convert real and imaginary coefficients into a complex number.
  • The square root of a complex number is:

    Equation

    where:

    Equation

    and:

    Equation

    and:

    Equation




Show: