IMSQRT
Formulas / IMSQRTCalculate 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.
Need help with Formulas?
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?
What kind of argument does the IMSQRT function take?
Are there any special considerations 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
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.