Returns the error function integrated between lower and upper limits.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 0.842700793
Calculates the error function from 0 to 1.
=ERF(0, 1)결과: 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.