IMSQRT Function in Excel returns the square root of a complex number.
Syntax of IMSQRT Function in Excel
IMSQRT ( inumber )
Where inumber argument is a Complex Number that you want to find the square root of.
Example of IMSQRT Function in Excel
Formula
- From Row number 2 to 5 IMSQRT Function takes up complex number as a reference
- In row number 6 IMSQRT Function takes up complex number(imaginary component) as a value which should be enclosed in double quotes.
- In row number 7 IMSQRT Function takes up real component as a value.
Result
NOTE: #NUM! – Error occurs if,
- supplied inumber argument is not recognized as a complex number.