The Excel ERF.PRECISE Function

Error Function

The Error function is given by the equation:

Error Function 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

For further details, see the Wikipedia Error Function page
Related Functions:
ERF
ERFC.PRECISE

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 syntax of the Erf.Precise function is:

ERF.PRECISE( x )

where x is the supplied lower or upper integral limit.


Erf.Precise Function Examples

In the following spreadsheet, the Excel Erf.Precise function is used to calculate the Error Function integrated between 0 and a supplied lower or upper limit.

 Formulas:
 AB
1=ERF.PRECISE( -1 ) - error function integrated between -1 & 0
2=ERF.PRECISE( 1.5 ) - error function integrated between 0 & 1.5
 Results:
 AB
1-0.842700793 - error function integrated between -1 & 0
2-0.966105146 - error function integrated between 0 & 1.5

Further examples of the Excel Erf.Precise function are provided on the Microsoft Office website.


Erf.Precise Function Error

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

Common Error
#VALUE!-Occurs if the supplied value of x is non-numeric.