Google Sheets
ERFC function in Google Sheets
Returns the complementary Gauss error function of a value.
=ERFC(z)ERFC syntax and parameters
One argument, one required.
- znumberRequired
The number for which to calculate the complementary Gauss error function.
ERFC examples
Formulas you'll actually reuse.
The complementary error function 1 − ERF(x) — a Gaussian tail:
=ERFC(B2)Result
0.1573The two-sided tail probability of a z-score — P(|Z| > z):
=ERFC(B2 / SQRT(2))Result
0.3173
ERFC in Excel
Same name — your formula ports as-is.
Try ERFC in the playground
Edit the example — nothing to install.
Preloaded with the ERFC formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ABSReturns the absolute value of a number.MathExcel
- ACOSReturns the inverse cosine of a value, in radians.MathExcel
- ACOSHReturns the inverse hyperbolic cosine of a number.MathExcel
- ACOTReturns the inverse cotangent of a value, in radians. .MathExcel
- ACOTHReturns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..MathExcel
- ASINReturns the inverse sine of a value, in radians.MathExcel