Formualizer Docs
ReferenceFunctionsMath Functions

POWER

Raises a base number to a specified power.

Summary

Raises a base number to a specified power.

Remarks

  • Equivalent to exponentiation (base^exponent).
  • Negative bases with fractional exponents return #NUM!.
  • Errors are propagated.

Examples

Integer exponent
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1024
Fractional exponent
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3

FAQ

Why can POWER return #NUM! for negative bases?

Negative bases with fractional exponents are rejected to avoid complex-number results.

Runtime metadata

Category

Math

Signature

POWER(arg1: Number, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

PI

PI: Returns the mathematical constant π.

QUOTIENT

QUOTIENT: Returns the integer portion of a division result, truncated toward zero.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy can POWER return #NUM! for negative bases?Runtime metadata