Formualizer Docs
ReferenceFunctionsEngineering Functions

IMSUM

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

Summary

Adds real parts together and imaginary parts together.

Remarks

  • Each argument is coerced to complex-number text before parsing.
  • Accepts any number of arguments from one upward.
  • Invalid complex text returns #NUM!.

Examples

Add multiple complex values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
9+2i
Add j-suffix values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
j

FAQ

Can IMSUM take more than two arguments?

Yes. It is variadic and sums all provided complex arguments in sequence.

Runtime metadata

Category

Engineering

Signature

IMSUM(arg1…: Any)

This function accepts a repeating argument pattern (min args: 1).

Arity

min 1, max variadic

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

IMSUB

IMSUB: Returns the difference between two complex numbers.

OCT2BIN

OCT2BIN: Converts an octal text value to binary text.

On this page

SummaryRemarksExamplesRelated functionsFAQCan IMSUM take more than two arguments?Runtime metadata