Formualizer Docs
ReferenceFunctionsEngineering Functions

IMDIV

IMDIV: Returns the quotient of two complex numbers.

Summary

Divides the first complex value by the second.

Remarks

  • Inputs are coerced to complex-number text before parsing.
  • Returns #DIV/0! when the divisor is 0+0i.
  • Invalid complex text returns #NUM!.

Examples

Divide complex numbers
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-0.5+3.5i
Division by zero complex
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#DIV/0!

FAQ

When does IMDIV return #DIV/0!?

If the divisor is 0+0i (denominator magnitude near zero), division is undefined and returns #DIV/0!.

Runtime metadata

Category

Engineering

Signature

IMDIV(arg1: Any, arg2: Any)

Arity

min 2, max 2

Arguments

arg1

Any · Scalar

arg2

Any · Scalar

Caps

PURE

Source

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

IMCOS

IMCOS: Returns the cosine of a complex number.

IMEXP

IMEXP: Returns the complex exponential of a complex number.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does IMDIV return #DIV/0!?Runtime metadata