IMSQRT

Formulas / IMSQRT
Calculate the square root of a complex number.
=IMSQRT(inumber)
  • inumber - required, a complex number used to get the square root

Examples

  • =IMSQRT("1+i")

    The IMSQRT function can calculate the square root of a complex number. For example, this formula returns 1.09868411346781+0.455089860562227i.

  • =IMSQRT("1+i", TRUE)

    The IMSQRT function can also calculate the square root of a complex number in polar form. For instance, this example returns 1.27201964951406∠45°.

  • =IMSQRT(SUM(1,2,3,4))

    The IMSQRT function can also be used in combination with other Sourcetable functions. This example returns 1.82574185835055+0i.

  • =IMSQRT(25)

    The IMSQRT function can be used to calculate the square root of a real number. For instance, this example returns 5+0i.


Summary

The IMSQRT function is used to calculate the square root of a complex number. The input should be a complex number expressed in the form of x + yi or x + yj. The output is a complex number with the same format.

  • The IMSQRT function calculates the square root of a complex number which is formatted as x + yi or x + yj.
  • The IMSQRT function takes a complex number as its argument, and the result is returned as a complex number.

Frequently Asked Questions

What is the IMSQRT function?
The IMSQRT function is used to calculate the square root of a complex number.
What kind of argument does the IMSQRT function take?
IMSQRT takes a complex number as its argument, which should be formatted as x + yi or x + yj.
Are there any special considerations when using the IMSQRT function?
Yes, there are some important things to consider when using the IMSQRT function:
  • The complex number should be formatted as x + yi or x + yj
  • Be aware that the result of the IMSQRT calculation may be an imaginary number
  • Always double check your results for accuracy
Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV