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.
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.
Need help with Formulas?
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.