ReferenceFunctionsEngineering Functions

COMPLEX

Builds a complex number text value from real and imaginary coefficients.

Summary

Returns canonical text such as 3+4i or -2j.

Remarks

real_num and i_num are numerically coerced.
suffix may be "i", "j", empty text, or omitted; empty/omitted defaults to i.
Any other suffix returns #VALUE!.

Examples

Build with default suffix

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

3+4i

Build with j suffix

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

-j

FAQ

Which suffix values are valid in `COMPLEX`?

Only suffixes i or j are accepted (empty or omitted defaults to i); other suffix strings return #VALUE!.

Runtime metadata

Category

Engineering

Signature

COMPLEX(arg1: Any, arg2: Any, arg3…: Any)

Arity

min 2, max variadic

Arguments

arg1

Any · Scalar

arg2

Any · Scalar

arg3

Any · Scalar

Caps

PURE

Source

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

BITXOR

BITXOR: Returns the bitwise exclusive OR of two non-negative integers.

CONVERT

Converts a numeric value from one supported unit to another.

On this page

Summary Remarks Examples Related functions FAQ Which suffix values are valid in COMPLEX?Runtime metadata