Edit

Share via


WorksheetFunction.GeStep(Object, Object) Method

Definition

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.

public double GeStep (object Arg1, object Arg2);
Public Function GeStep (Arg1 As Object, Optional Arg2 As Object) As Double

Parameters

Arg1
Object

Number - the value to test against step.

Arg2
Object

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

Returns

Remarks

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

Applies to