Microsoft Office Tutorials and References
In Depth Information
ERFC
ERF ERFC returns a complementar y ERF function integrated between x and infinity. X is the
lowerbound for integrating ERF .
=ERFC(x)
The ERFC 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.14.
X The numeric lower-bound for integrating the ERF .
The equation is as follows:
Figure 5.14
Returns a
complementary ERFC function
integrated between x
and infinity—x is the
lower-bound for
integrating ERFC .
GESTEP
The GESTEP function returns the value of 1 if the number is greater than or equal to a
specified step value, other wise 0.
=GESTEP(number,step)
The GESTEP 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.15. Where the
number is equal to or greater than the step, the result is 1. Other wise the result is zero. You
can use this to sum up only those values that exceed the step value.
The number to test against the step value.
NUMBER
The step value is the threshold value the number is tested upon.
If the value for step is omitted, it assumes zero.
STEP
Search JabSto ::




Custom Search