Formualizer Docs
ReferenceFunctionsEngineering Functions

IMSUB

IMSUB: Returns the difference between two complex numbers.

Summary

Subtracts the second complex value from the first.

Remarks

  • Inputs are coerced to complex-number text before parsing.
  • Output keeps the suffix style from the parsed inputs.
  • Invalid complex text returns #NUM!.

Examples

Subtract a+bi values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3+2i
Subtract pure imaginary from real
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
4-7j

FAQ

How is subtraction ordered in IMSUB?

It always computes inumber1 - inumber2; swapping arguments changes the sign of the result.

Runtime metadata

Category

Engineering

Signature

IMSUB(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

IMSQRT

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

IMSUM

IMSUM: Returns the sum of one or more complex numbers.

On this page

SummaryRemarksExamplesRelated functionsFAQHow is subtraction ordered in IMSUB?Runtime metadata