Export (0) Print
Expand All
Expand Minimize

WorksheetFunction.GeStep Method (Excel)

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.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Variant

Number - the value to test against step.

Arg2

Optional

Variant

Step - the threshold value. If you omit a value for step, GESTEP uses zero.

Return Value

Double

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

Show:
© 2014 Microsoft