IMSQRT function
The IMSQRT function computes the square root of a complex number.
Parts of a IMSQRT function​
The IMSQRT formula is formatted as =IMSQRT(complex_number).
Sample formulas​
IMSQRT(2)
IMSQRT("3+2i")
Notes​
- This function is equivalent to using
IMPOWER(complex_number, 0.5). - While it is not possible to use the
SQRTfunction to take the square root of a negative real number, it is possible to useIMSQRTto take the square root of a complex number with a negative real number component.
Examples​
| A | B | |
|---|---|---|
| 1 | Formula | Result |
| 2 | =IMSQRT(4) | 2 |
| 3 | =IMSQRT("3+4i") | 2+i |
| 4 | =IMSQRT("3-4j") | 2-j |
| 5 | =IMSQRT(COMPLEX(3, 4)) | 2+i |
Related functions​
IMPOWER: The IMPOWER function returns a complex number raised to a power.
COMPLEX: The COMPLEX function creates a complex number, given real and imaginary coefficients.