The Excel ERFC function calculates the Complementary Error Function, integrated between a supplied lower limit and infinity.
The Complementary Error Function is equal to 1 -ERF (i.e. 1 – Error Function), and is given by the equation:
The ERFC function syntax has the following arguments:
- X Required. The lower bound for integrating ERFC.
Example: Let’s look at some Excel ERFC function examples and explore how to use the ERFC function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following ERFC examples would return:
- If x is a non-numeric value, the function returns the #VALUE! error value.
- The function returns the #NUM! error if one or both of the arguments are negative in Excel 2007 or earlier versions of Excel.