Information
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.

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

Show:
© 2014 Microsoft. All rights reserved.