This function is only available if the Analysis AddIn is installed.
Syntax:
IMSQRT(complexnumber)
complexnumber is text representing a complex number, for example as a+bi or a+bj.
IMSQRT returns the square root of complexnumber as text. That is, if complexnumber is a0+b0i, it returns a1+b1i, such that (a1+b1i) * (a1+b1i) = a0+b0i.
Example:
IMSQRT("16+30i")
returns 5+3i as text.
Issues:
This function currently appears in the AddIn category of the Function Wizard.