WorksheetFunction.GeStep Method
| Excel Developer Reference |
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.
See Also