Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

WorksheetFunction.GeStep Method

Office 2007
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.


expression.GeStep(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.


NameRequired/OptionalData TypeDescription
Arg1RequiredVariantNumber - the value to test against step.
Arg2OptionalVariantStep - the threshold value. If you omit a value for step, GESTEP uses zero.

Return Value


If any argument is nonnumeric, GESTEP returns the #VALUE! error value.

Community Additions

© 2015 Microsoft