Formualizer Docs
ReferenceFunctionsEngineering Functions

IMLOG2

IMLOG2: Returns the base-2 logarithm of a complex number.

Summary

Produces the principal complex logarithm in base 2.

Remarks

  • Input is coerced to complex-number text before parsing.
  • Returns #NUM! for zero input.
  • Invalid complex text returns #NUM!.

Examples

Base-2 log of a real value
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3
Base-2 log on imaginary axis
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2.266180070913597i

FAQ

When does IMLOG2 return #NUM!?

It returns #NUM! for invalid complex text or zero input, where logarithm is undefined.

Runtime metadata

Category

Engineering

Signature

IMLOG2(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

IMLOG10

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

IMPOWER

IMPOWER: Raises a complex number to a real power.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does IMLOG2 return #NUM!?Runtime metadata