Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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




Community Additions

ADD
Show:
© 2015 Microsoft