Documentation/Calc Functions/GESTEP
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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:
Related (or similar) Excel functions:
GESTEP