# The Excel IMSQRT Function

Related Function:
IMPOWER Function

## Function Description

The Excel Imsqrt function returns the square root of a supplied complex number.

The syntax of the function is:

IMSQRT( inumber )

Where the inumber argument is the complex number that you want the square root of.

## Excel Imsqrt Function Examples

In the spreadsheets below, the Excel Imsqrt function is used to calculate the square root of five different complex numbers.

Formulas:
A
1=IMSQRT( "i" )
2=IMSQRT( "2-i" )
3=IMSQRT( "5+2i" )
4=IMSQRT( 6 )
5=IMSQRT( "-2-4i" )
Results:
A
10.707106781186548+0.707106781186547i
21.45534669022535-0.343560749722512i
32.27872385417085+0.438842116902255i
42.44948974278318
51.11178594050284-1.79890743994787i

Note that, in the above example spreadsheet, the integer 6, used in cell B4, is equal to the complex number 6+0i.

More details and examples of the Excel Imsqrt function are provided on the Microsoft Office website.

## Imsqrt Function Errors

If you get an error from the Excel Imsqrt Function, this is likely to be one of the following:

Common Errors
 #NUM! - Occurs if the supplied inumber argument is not recognised as a complex number. #VALUE! - Occurs if the supplied inumber argument is a logical value.