Formualizer Docs
ReferenceFunctionsEngineering Functions

IMLN

IMLN: Returns the natural logarithm of a complex number.

Summary

Produces the principal complex logarithm as text.

Remarks

  • Input is coerced to complex-number text before parsing.
  • Returns #NUM! for zero input because ln(0) is undefined.
  • Invalid complex text returns #NUM!.

Examples

Natural log of 1
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0
Natural log on imaginary axis
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1.5707963267948966i

FAQ

Why does IMLN(0) return #NUM!?

The complex logarithm at zero is undefined, so this implementation returns #NUM!.

Runtime metadata

Category

Engineering

Signature

IMLN(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

IMEXP

IMEXP: Returns the complex exponential of a complex number.

IMLOG10

IMLOG10: Returns the base-10 logarithm of a complex number.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does IMLN(0) return #NUM!?Runtime metadata