ReferenceFunctionsEngineering Functions

IMAGINARY

Returns the imaginary coefficient of a complex number.

Summary

Accepts complex text (for example a+bi) or numeric values.

Remarks

Inputs are coerced to complex-number text before parsing.
Purely real values return 0.
Invalid complex text returns #NUM!.

Examples

Imaginary part from a+bi

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

4

Imaginary part with j suffix

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

-2

FAQ

What does `IMAGINARY` return for a real-only input?

It returns 0 because there is no imaginary component.

Runtime metadata

Category

Engineering

Signature

IMAGINARY(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

IMABS

IMABS: Returns the modulus (absolute value) of a complex number.

IMARGUMENT

IMARGUMENT: Returns the argument (angle in radians) of a complex number.

On this page

Summary Remarks Examples Related functions FAQ What does IMAGINARY return for a real-only input?Runtime metadata