Documentation/Calc Functions/GESTEP

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  performs an identical function but returns the result of the comparison as TRUE or FALSE rather than 1 or 0.

Related LibreOffice functions:
None.

ODF standard:
Section 6.16.37, part 2

Equivalent Excel functions:
GESTEP