Formualizer Docs
ReferenceFunctionsEngineering Functions

ERF

ERF: Returns the Gaussian error function over one bound or between two bounds.

Summary

With one argument it returns erf(x); with two it returns erf(upper) - erf(lower).

Remarks

  • Inputs are numerically coerced.
  • A second argument switches the function to interval mode.
  • Results are approximate floating-point values.

Examples

Single-bound ERF
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.8427007929497149
Interval ERF
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.8427007929497149

FAQ

How does two-argument ERF work?

ERF(lower, upper) returns erf(upper) - erf(lower), i.e., an interval difference rather than a single-bound value.

Runtime metadata

Category

Engineering

Signature

ERF(arg1: Number, arg2…: Number)

Arity

min 1, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

DELTA

DELTA: Tests whether two numbers are equal.

ERF.PRECISE

ERF.PRECISE: Returns the error function of a number.

On this page

SummaryRemarksExamplesRelated functionsFAQHow does two-argument ERF work?Runtime metadata