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.
