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).
| Part | Description | Notes | | complex_number | The complex number to take the square root of. | |
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.