Returns the error function integrated between lower and upper limits.
Sintassi
ERF(lower_limit, [upper_limit])Argomenti
lower_limitobbligatorio
The lower bound for the integration of the error function.
upper_limitfacoltativo
The upper bound for the integration of the error function; if omitted, it defaults to 0.
The ERF function calculates the error function, which is defined as the integral of the Gaussian distribution. If only the lower limit is provided, the function integrates from 0 to that limit. If both limits are provided, it calculates the integral between the two specified values.
=ERF(1)→0.842700793Calculates the error function from 0 to 1.
=ERF(0, 1)→0.842700793Calculates the error function between 0 and 1, yielding the same result as the single argument version.
Select a cell
Click on the cell where you want to display the error function result.
Enter the formula
Type =ERF(lower_limit, [upper_limit]) and replace the arguments with your numeric values.
Press Enter
Press the Enter key to calculate the result.
The function will return a negative value, representing the integral in the reverse direction.
Yes, it is available in all modern versions of Excel as part of the Analysis ToolPak or built-in functions.