The Excel ERF.PRECISE Function

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

Related Functions:  ERF function ERFC function

Error Function

The Error function is given by the equation :

The Excel Erf.Precise function calculates this function with the upper or lower limit of the integral set to 0 (depending on whether the user-supplied limit is positive or negative).

If you want to choose both the upper and lower limits yourself, you should consider using the Erf function

Further information about the error function is given on the Wikipedia Error Function page

Basic Description

The Excel ERF.PRECISE function calculates the Error Function, integrated between a supplied lower or upper limit and 0.

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

The format of the Erf.Precise function is:

where x is the supplied lower or upper integral limit.

Formulas:

Results:

Examples

The spreadsheet on the right shows the Excel Erf.Precise function used to calculate the integral of the Error Function between 0 and a supplied lower or upper limit.

The top spreadsheet shows the format of the functions and the lower spreadsheet shows the function results.

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

Trouble Shooting

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