Documentation/Calc Functions/GESTEP

    From The Document Foundation Wiki
    Other languages:


    Function name:

    GESTEP

    Category:

    Add-in

    Summary:

    Determines whether a number is greater than or equal to a threshold or step value.

    Syntax:

    GESTEP(Number[; Step])

    Returns:

    Returns 1 to indicate that the given number is greater than or equal to the specified step and returns 0 otherwise.

    Arguments:

    Number is a real number, or a reference to the cell containing that number, which is the number to be compared to the Step argument.

    Step is a real number, or a reference to the cell containing that number, which is the threshold to be used in the comparison. If Step is omitted, the default value of 0 is used.

    • If Number is non-numeric, then GESTEP reports a #VALUE! error.
    • If Step is non-numeric (assuming that Number is numeric), then GESTEP reports an invalid argument error (Err:502).

    Additional details:

    A formula such as =Number>=Step performs an identical function but returns the result of the comparison as TRUE or FALSE rather than 1 or 0.

    Examples:

    Formula Description Returns
    =GESTEP(−0.5) Here the function compares -0.5 to the default step value of 0, returning 0. 0
    =GESTEP(0) Here the function compares 0 to the default step value of 0, returning 1. 1
    =GESTEP(0.5) Here the function compares 0.5 to the default step value of 0, returning 1. 1
    =GESTEP(−4; −5) Here the function compares -4 to the step value of -5, returning 1. 1
    =GESTEP(D1; D2) where cells D1 and D2 contain the values 7.6 and 7.6001 respectively. Here the function compares 7.6 to to the step value of 7.6001, returning 0. 0
    =5>=4 Here the formula compares 5 to 4, returning the value TRUE. TRUE

    Related LibreOffice functions:

    None.

    ODF standard:

    Section 6.16.37, part 2

    Related (or similar) Excel functions:

    GESTEP