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

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.