The IMSQRT function returns the square root of a complex number in x + yi or x + yj text format
The IMSQRT function syntax has the following arguments:
- Inumber: Required. A complex number for which you want the square root
Example: Let’s look at some Excel IMSQRT function examples and explore how to use the IMSQRT function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following IMSQRT examples would return:
- Use COMPLEX to convert real and imaginary coefficients into a complex number.
The square root of a complex number is: where: and: and: