The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.
This topic has not yet been rated - Rate this topic

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

© 2014 Microsoft. All rights reserved.