Formulas and Functions

Chapter 5 Engineering Functions 87
ERF
The ERF function returns the error function integrated between two values.
ERF(lower, upper)
 lower: The lower limit or bound. lower is a number value.
 upper: An optional argument specifying the upper limit or bound. upper is a
number value. If upper is omitted it is assumed to be 0.
Usage Notes
This function is also known as the Gauss error function. Â
Examples
=ERF(0, 1) returns 0.842700792949715.
=ERF(-1, 1) returns 1.68540158589943.
=ERF(1, 8) returns 0.157299207050285.
Related Topics
For related functions and additional information, see:
“ERFC” on page 87
“Listing of Engineering Functions” on page 72
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
ERFC
The ERFC function returns the complementary ERF function integrated between a
given lower bound and innity.
ERFC(lower)
 lower: The lower limit or bound. lower is a number value.
Examples
=ERFC(-1) returns 1.84270079294971.
=ERFC(1) returns 0.157299207050285.
=ERFC(12) returns 1.3562611692059E-64.