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
SQRT
function to take the square root of a negative real number, it is possible to useIMSQRT
to 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.