Formulas > =ERFC()

How To Use ERFC() Function in Google Sheets


Returns the complementary Gauss error function of a value.

Common Questions about the ERFC Formula:
- What does ERFC stand for?
- How do I use the ERFC formula?
- What types of calculations can the ERFC formula be used for?

How can the ERFC Formula be Used Appropriately:
- The ERFC formula can be used to calculate the cumulative probability of a normal or Gaussian distribution.
- It can be used to find the integral of a function from -infinity to the given parameter.
- The ERFC formula can also be used to calculate Gaussian error functions for statistical processes.

How can the ERFC Formula be Commonly Mistyped:
- ERF instead of ERFC
- NRFC instead of ERFC
- ERFO instead of ERFC
- Other common mistypes are  EFRC, ERCF, EFCR, RFC.

What are some Common Ways the ERFC Formula is Used Inappropriately:
- Using the ERFC formula for non-normal or non-Gaussian distributions.
- Expecting the ERFC formula to calculate probability beyond 1 or less than 0.
- Using the ERFC formula on data that is not trended or grouped.

What are some Common Pitfalls when Using the ERFC Formula:
- Not understanding what the ERFC formula is for and where it should be used appropriately.
- Failing to recognize when the formula is being misused or applied to the wrong data.
- Not accounting for trends or trends within the data.

What are Common Mistakes When Using the ERFC Formula:
- Misunderstanding the parameters of the formula and entering the wrong values.
- Not properly accounting for the shape of the data when using the ERFC Formula.
- Not double-checking the output of the ERFC Formula in order to verify its accuracy.

What are Common Misconceptions People Might Have With the ERFC Formula:
- That the ERFC formula will always give a definite answer and produce a certain result. 
- That the ERFC formula can be used to calculate probabilities outside of a Gaussian/normal distribution. 
- That the ERFC formula can be used to accurately calculate probabilities with non-trended data.

How To Actually Use ERFC() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the ERFC() formula:

Google Sheets ERFC Taylor Maclaurin SERIESSUM Expansion LINEST Polynomial Regression

This video shows the use of ARRAYFORMULA in the Taylor Maclaurin SERIESSUM of ERFC and it LINEST Polynomial Regression

Generate a ERFC() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.