Formualizer Docs
ReferenceFunctionsEngineering Functions

IMABS

IMABS: Returns the modulus (absolute value) of a complex number.

Summary

Computes sqrt(real^2 + imaginary^2).

Remarks

  • Inputs are coerced to complex-number text before parsing.
  • Returns a non-negative real number.
  • Invalid complex text returns #NUM!.

Examples

3-4-5 triangle modulus
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
5
Purely real input
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
5

FAQ

Can IMABS return a negative result?

No. It computes the modulus sqrt(a^2+b^2), which is always non-negative.

Runtime metadata

Category

Engineering

Signature

IMABS(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

HEX2OCT

HEX2OCT: Converts a hexadecimal text value to octal text.

IMAGINARY

Returns the imaginary coefficient of a complex number.

On this page

SummaryRemarksExamplesRelated functionsFAQCan IMABS return a negative result?Runtime metadata