Formualizer Docs
ReferenceFunctionsEngineering Functions

ERFC.PRECISE

ERFC.PRECISE: Returns the complementary error function of a number.

Summary

Computes 1 - ERF(x) using the same one-argument precise behavior as Excel ERFC.PRECISE.

Remarks

  • Accepts one numeric argument.
  • Numeric text is coerced using standard function coercion.
  • Results are approximate floating-point values.

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

How is ERFC.PRECISE different from ERFC?

It exposes the precise one-argument complement form; numerically it matches ERFC(x) in this implementation.

Runtime metadata

Category

Engineering

Signature

ERFC.PRECISE(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

ERFC

ERFC: Returns the complementary 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 functionsFAQHow is ERFC.PRECISE different from ERFC?Runtime metadata