Returns 1 if number ³ step; returns 0 (zero) otherwise. Use this function to filter a set of values. For example, by summing several GESTEP functions you calculate the count of values that exceed a threshold.
If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.
Syntax
GESTEP(number,step)
Number is the value to test against step.
Step is the threshold value. If you omit a value for step, GESTEP uses zero.
Remarks
If any argument is nonnumeric, GESTEP returns the #VALUE! error value.
Examples
GESTEP(5, 4) equals 1
GESTEP(5, 5) equals 1
GESTEP(-4, -5) equals 1
GESTEP(-1, 0) equals 0