ReferenceFunctionsEngineering Functions

IMSQRT

IMSQRT: Returns the principal square root of a complex number.

Summary

Computes the root in polar form and returns complex text.

Remarks

Input is coerced to complex-number text before parsing.
Returns the principal branch of the square root.
Invalid complex text returns #NUM!.

Examples

Square root of a negative real

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

2i

Square root of a+bi

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

2+i

FAQ

Which square root does `IMSQRT` return for complex inputs?

It returns the principal branch (half-angle polar form), matching spreadsheet-style principal-value behavior.

Runtime metadata

Category

Engineering

Signature

IMSQRT(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/engineering.rs

IMSIN

IMSIN: Returns the sine of a complex number.

IMSUB

IMSUB: Returns the difference between two complex numbers.

On this page

Summary Remarks Examples Related functions FAQ Which square root does IMSQRT return for complex inputs?Runtime metadata