Jump to content

Documentation/Calc Functions/GESTEP

From The Document Foundation Wiki


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