Formualizer Docs
ReferenceFunctionsEngineering Functions

IMARGUMENT

IMARGUMENT: Returns the argument (angle in radians) of a complex number.

Summary

The angle is measured from the positive real axis.

Remarks

  • Inputs are coerced to complex-number text before parsing.
  • Returns #DIV/0! for 0+0i, where the angle is undefined.
  • Invalid complex text returns #NUM!.

Examples

First-quadrant angle
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.7853981633974483
Negative real axis
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3.141592653589793

FAQ

Why does IMARGUMENT(0) return #DIV/0!?

The argument (angle) of 0+0i is undefined, so the function returns #DIV/0!.

Runtime metadata

Category

Engineering

Signature

IMARGUMENT(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

IMAGINARY

Returns the imaginary coefficient of a complex number.

IMCONJUGATE

IMCONJUGATE: Returns the complex conjugate of a complex number.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does IMARGUMENT(0) return #DIV/0!?Runtime metadata