Formualizer Docs
ReferenceFunctionsEngineering Functions

ERFC

ERFC: Returns the complementary error function of a number.

Summary

ERFC(x) is equivalent to 1 - ERF(x).

Remarks

  • Input is numerically coerced.
  • Results are approximate floating-point values.
  • Propagates input errors.

Examples

Complement at one
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.1572992070502851
Complement at zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1

FAQ

Is ERFC(x) equivalent to 1-ERF(x) here?

Yes. It computes the complementary error function and matches 1 - erf(x) behavior.

Runtime metadata

Category

Engineering

Signature

ERFC(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ERF.PRECISE

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

GESTEP

GESTEP: Returns `1` when a number is greater than or equal to a step value.

On this page

SummaryRemarksExamplesRelated functionsFAQIs ERFC(x) equivalent to 1-ERF(x) here?Runtime metadata