IMSQRT Function in Excel – Get the square root of a complex number

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

IMSQRT Function in Excel 1

  • 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

IMSQRT Function in Excel 2

NOTE: #NUM! – Error occurs if,

  • supplied inumber argument is not recognized as a complex number.

previous-small IMSQRT Function in Excel                                                                                                                next_small IMSQRT Function in Excel