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