WorksheetFunction.ImSqrt Method

  • Article
Excel Developer Reference

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

Name Required/Optional Data Type Description
Arg1 Required Variant Inumber - 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

See Also