Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
IMSQRT
Returns the square root of a complex number.
Rarely usedDifficulty 1500 · AdvancedUsage rank #501 of 520
When to use it
The principal square root of a complex number.
The shape of it
- Syntax
=IMSQRT(inumber)
Worked examples
Typical
=IMSQRT("1+i") → 1.09868411346781+0.455089860562227i
A typical result.
Negative real
=IMSQRT("-4") → 2i
The square root of a negative number.
Positive real
=IMSQRT("4") → 2
A positive real.
Worth knowing
- Solve quadratics with negative discriminants: IMSQRT(COMPLEX(disc,0)).
- Same as IMPOWER(z,0.5).
- Result is text.
Where it goes wrong
- #VALUE! for invalid text.
- Only the principal root is returned; negate it for the other.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.