Returns the error function integrated between lower and upper limits.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
ERF(lower_limit, [upper_limit])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)Ergebnis: 0.842700793
Calculates the error function from 0 to 1.
=ERF(0, 1)Ergebnis: 0.842700793
Calculates the error function between 0 and 1, yielding the same result as the single argument version.
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.