Engineering

IMSQRT Function in Excel

Returns the square root of a complex number.

Syntax

  • =IMSQRT(inumber)

Arguments

  • inumber (required): Complex number

Examples

  • =IMSQRT("1+i") - Square root of 1+i - Result: 1.099+0.455i

IMSQRT in technical sheets

  • Document units in adjacent cells — many engineering functions require exact unit strings.
  • Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
  • Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

  • #NUM! if not valid complex number

Use cases

  • Complex analysis
  • Engineering
  • Mathematics

Frequently asked questions

  • What is the IMSQRT function in Excel? IMSQRT returns the square root of a complex number. The syntax is =IMSQRT(inumber). Typical use cases include complex analysis, engineering, mathematics.
  • How do I use the IMSQRT function? To use IMSQRT, type =IMSQRT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is IMSQRT not working in my Excel? Common issues with IMSQRT include #NUM! if not valid complex number. Start by checking the syntax =IMSQRT(inumber), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use IMSQRT

  • Complex analysis — common Engineering scenario for IMSQRT.
  • Engineering — common Engineering scenario for IMSQRT.
  • Mathematics — common Engineering scenario for IMSQRT.

IMSQRT in the Engineering category

  • Browse all Engineering functions at /categories/engineering/ for related formulas.
  • IMSQRT syntax: =IMSQRT(inumber)
  • inumber (required): Complex number
  • Confirm IMSQRT arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm IMSQRT arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • IMPOWER (/functions/impower/): Returns a complex number raised to an integer power.
  • COMPLEX (/functions/complex/): Converts real and imaginary coefficients into a complex number.
  • SQRT (/functions/sqrt/): Returns the square root of a number.

Errors to watch for

  • #NUM! if not valid complex number — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter IMSQRT on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

IMSQRT worked examples to copy

  • =IMSQRT("1+i") — Square root of 1+i. Expected result: 1.099+0.455i.

IMSQRT reference summary for crawlers and offline review

  • IMSQRT belongs to the Engineering category in Excel. Returns the square root of a complex number.
  • Full syntax: =IMSQRT(inumber). Open /functions/imsqrt/ for parameters, FAQs, and related pages.
  • Common mistakes: #NUM! if not valid complex number
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.