Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
GeStep Method
Collapse the table of content
Expand the table of content

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:
© 2015 Microsoft