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.

Syntax

expression.GeStep(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.

Parameters

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
Double

Remarks

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




Community Additions

ADD
Show:
© 2015 Microsoft