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.
|x||The supplied lower bound for integrating ERF.PRECISE|
|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:
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