IMSQRT
returns square root of complex number · from excel · excel: not yet compared · sheets: not yet compared
signature
IMSQRT(inumber)
returns: text (complex number)
| argument | required |
|---|---|
| inumber | required |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
fx
=IMSQRT("1+i") 1.09868411346781+0.455089860562227i