How to use ERFC Function in Excel

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:

Syntax: =ERFC(x)

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:

Syntax:  =ERFC(A2)

Result:

Based on the Excel spreadsheet above, the following ERFC examples would return:

Note:

• 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.