Engineering - ERF Function

Description

The ERF function returns the error function integrated between lower_limit and upper_limit.

The Error function is given by the equation −

$$Erf(x)=\frac{2}{\sqrt{\pi}}\int e^{-t^2}dt$$

Syntax

ERF (lower_limit, [upper_limit])

Arguments

Argument Description Required/ Optional
lower_limit The lower bound for integrating ERF. Required
upper_limit

The upper bound for integrating ERF.

If omitted, ERF integrates between zero and lower_limit.

 Optional

Notes

  • If lower_limit is nonnumeric, ERF returns the #VALUE! error value.

  • If upper_limit is nonnumeric, ERF returns the #VALUE! error value

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

  • In Excel 2007, if you input a negative value for the upper or lower limit, the function would return #NUM! error value.

  • In Excel 2010, the function algorithm has been improved, so that it can now calculate the function for both positive and negative ranges.

Example

ERF Function
advanced_excel_engineering_functions.htm
Advertisements