ReferenceFunctionsEngineering Functions

IMREAL

IMREAL: Returns the real 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 imaginary values return 0.
Invalid complex text returns #NUM!.

Examples

Real part from a+bi

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

3

Real part of pure imaginary

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

0

FAQ

What does `IMREAL` return for a purely imaginary input?

It returns 0 because the real coefficient is zero.

Runtime metadata

Category

Engineering

Signature

IMREAL(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

IMPRODUCT

IMPRODUCT: Returns the product of one or more complex numbers.

IMSIN

IMSIN: Returns the sine of a complex number.

On this page

Summary Remarks Examples Related functions FAQ What does IMREAL return for a purely imaginary input?Runtime metadata