The Excel ERFC.PRECISE Function

Home » Excel-Built-In-Functions » Excel-Engineering-Functions » Excel-Erfc.Precise-Function Search this site: Custom Search

Related Functions:  ERFC ERF.PRECISE

Complementary Error Function

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

The Error Function is described in more detail on the Wikipedia Error Function page

Basic Description

The Excel ERFC.PRECISE function calculates the Complementary Error Function, integrated between a supplied lower limit and infinity.

The function is new in Excel 2010 and so is not available in earlier versions of Excel. However, it is similar to the Erfc function, which is available in earlier versions of Excel.

The format of the Erfc.Precise function is:

where x is the lower limit of the complementary error function integral.

Examples

The spreadsheets below show the Excel Erfc.Precise function used to calculate the Complementary Error Function between various supplied lower limits and infinity.

The spreadsheet on the left shows the format of the functions and the spreadsheet on the right shows the function results.

Formulas:

Results:

Further examples of the Excel Erfc.Precise function can be found on the Microsoft Office website.

Trouble Shooting

If you get an error from the Excel Erfc.Precise function this is most likely to be the #VALUE! error :