WorksheetFunction.GeStep Method

  • Article

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.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function GeStep ( _
    Arg1 As Object, _
    Arg2 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim Arg2 As Object
Dim returnValue As Double

returnValue = instance.GeStep(Arg1, Arg2)

double GeStep(
    Object Arg1,
    Object Arg2
)

Parameters

  • Arg1
    Type: System.Object

    Number - the value to test against step.

  • Arg2
    Type: System.Object

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

Return Value

Type: System.Double

Remarks

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

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace