Related Functions:

The ERF.PRECISE function returns the error function integrated between a supplied lower limit and 0.

  • This function was introduced in Excel 2010 and so is not available in earlier versions. However, it is similar to the ERF function, which is available in earlier versions of Excel.




Argument Description
x The supplied lower bound for integrating ERF.PRECISE


  A B C
1 Formula Result Notes
2 =ERF.PRECISE(0.745) 0.70792892 Error function integrated between 0 and 0.74500
3 =ERF.PRECISE(1) 0.84270079 Error function integrated between 0 and 1
4 =ERF.PRECISE(-1) -0.84270079 Error function integrated between -1 and 0

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if x, the lower limit, is nonnumeric

The Error function is given by the equation:

    \[Erf(x)=\frac{2}{\sqrt{\pi}}\int e^{-t^2}dt\]

The 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, i.e.

  • if x is assigned a negative value, the upper limit is set to zero
  • if x is assigned a positive value, the lower limit is set to zero

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