WorksheetFunction.GeStep Method (Excel)
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.
Syntax
expression .GeStep(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
Required |
Variant |
Number - the value to test against step. |
Arg2 |
Optional |
Variant |
Step - the threshold value. If you omit a value for step, GESTEP uses zero. |
Return Value
Double
Remarks
If any argument is nonnumeric, GESTEP returns the #VALUE! error value.