دالة Google Sheets

ERF

Returns the error function integrated between lower and upper limits.

إنشاء صيغة بالذكاء الاصطناعي نفس الدالة في Excel

تعمل هذه الدالة في 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.

المعاملات

lower_limitمطلوبThe lower bound for the integration of the error function.
upper_limitاختياريThe upper bound for the integration of the error function; if omitted, it defaults to 0.

أمثلة

=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.

الأسئلة الشائعة

What happens if the lower_limit is greater than the upper_limit?

The function will return a negative value, representing the integral in the reverse direction.

Is the ERF function available in all versions of Excel?

Yes, it is available in all modern versions of Excel as part of the Analysis ToolPak or built-in functions.

دوال ذات صلة

ERFC