Spread.NET 17 Formula Reference
Formula Functions / Functions D to G / GESTEP
In This Topic
    GESTEP
    In This Topic

    This function, greater than or equal to step, returns an indication of whether a number is equal to a threshold.

    Syntax

    GESTEP(number,step)

    Arguments

    This function has these arguments:

    Argument Description
    number Value to test against the step (which is either step or zero)
    step [Optional] Value of the threshold against which to test; if omitted, uses zero

    Remarks

    If the number is greater than or equal to the step, this function returns one. Otherwise it returns zero.

    Data Types

    Accepts numeric data for all arguments. Returns numeric (0 or 1) data.

    Examples

    GESTEP(B5,7)

    GESTEP(43) gives the result 1

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    DELTA | Engineering Functions