Engineering - ERFC.PRECISE Function

Description

The ERFC.PRECISE function returns the complementary ERF function integrated between x and infinity.

The Complementary Error Function is equal to 1 - ERF (i.e. 1 - Error Function), and is given by the equation −

$$Erfc(x)=\frac{2}{\sqrt{\pi}}\int_{x}^{\infty} e^{-t^2}dt$$

Syntax

ERFC.PRECISE(x)

Arguments

Notes

If x is nonnumeric, ERFC.PRECISE returns the #VALUE! Error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example