Microsoft Office Tutorials and References

In Depth Information

**ERF**

Figure 5.12

DELTA
tests whether

two numbers are equal

with a numeric result.

ERF
Use the
ERF
function to return the integrated error function between a lower and upper limit.

=ERF(lower_limit,upper_limit)

The
ERF
function is found only if the Analysis-Toolpak is installed. In addition it must be

turned on in the Add-Ins from the Tools menu. Notice the example in Figure 5.13. The

lowerbound limit in the first example is 2 and the upper-bound limit is 3. The error result is .0047.

The numeric lower-bound for integrating the function.

LOWER LIMIT

The numeric upper-bound for integrating the function.

UPPER LIMIT

The equations are as follows:

Figure 5.13

Returns the integrated

error function for upper

and lower-bound limits.