WorksheetFunction.ImSqrt Method (Excel)

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


expression. ImSqrt( _Arg1_ )

expression A variable that represents a WorksheetFunction object.


Name Required/Optional Data Type Description
Arg1 Required Variant Inumber - a complex number for which you want the square root.

Return Value



  • Use COMPLEX to convert real and imaginary coefficients into a complex number.

  • The square root of a complex number is: Formulawhere: Formulaand: Formulaand: Formula

See also

WorksheetFunction Object