Skip to content
Excel

IMSQRT function in Excel

Returns the square root of a complex number

=IMSQRT(inumber)

IMSQRT syntax and parameters

One argument, one required.

  • inumberstringRequired

    A complex number for which you want the square root.

IMSQRT examples

Formulas you'll actually reuse.

  1. The square root of a negative number, as a complex result:

    =IMSQRT("-4")

    Result"2i"

  2. The principal square root of a complex number:

    =IMSQRT("3+4i")

    Result"2+i"

IMSQRT in Google Sheets

Same name — your formula ports as-is.

Try IMSQRT in the playground

Edit the example — nothing to install.

Preloaded with the IMSQRT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.