Formualizer Docs
ReferenceFunctionsEngineering Functions

IMPOWER

IMPOWER: Raises a complex number to a real power.

Summary

Uses polar form and returns the principal-value result as complex text.

Remarks

  • inumber is coerced to complex-number text; n is numerically coerced.
  • Returns #NUM! for undefined zero-power cases such as 0^0 or 0^-1.
  • Invalid complex text returns #NUM!.

Examples

Square a complex value
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2i
Negative real exponent
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.5

FAQ

How does IMPOWER handle zero base with non-positive exponent?

0^0 and 0 raised to a negative exponent are treated as undefined and return #NUM!.

Runtime metadata

Category

Engineering

Signature

IMPOWER(arg1: Any, arg2: Any)

Arity

min 2, max 2

Arguments

arg1

Any · Scalar

arg2

Any · Scalar

Caps

PURE

Source

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

IMLOG2

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

IMPRODUCT

IMPRODUCT: Returns the product of one or more complex numbers.

On this page

SummaryRemarksExamplesRelated functionsFAQHow does IMPOWER handle zero base with non-positive exponent?Runtime metadata