Skip to main content

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 use IMSQRT to take the square root of a complex number with a negative real number component.

Examples​

AB
1FormulaResult
2=IMSQRT(4)2
3=IMSQRT("3+4i")2+i
4=IMSQRT("3-4j")2-j
5=IMSQRT(COMPLEX(3, 4))2+i

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.