GESTEP in Collabora Office: Build Inclusive Numeric Threshold Indicators
Use Collabora GESTEP for greater-than-or-equal tests, a zero default and transparent interval indicators.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =GESTEP(10;10) has independently expected result 1. Equality is included: GESTEP returns one when Number is greater than or equal to Step, otherwise zero.
Syntax and the optional threshold
=GESTEP(Number [; Step])
Number is the numeric value to test. Step is the threshold. The dedicated Collabora help marks Step optional; the corroborating Analysis implementation supplies zero when that optional argument is omitted.
The result is a numeric 1 or 0. It is not the distance from the threshold, a rank or the original number. Negative values and negative thresholds can be compared normally; a custom Step changes the question from a simple nonnegative test.
The current implementation performs a direct >= comparison. It does not introduce an application-specific tolerance for nearly equal numbers.
Example 1: audit both sides of a threshold
Put 8, 9, 10, 11 and 12 in A2:A6. Put threshold 10 in F1. Enter =GESTEP(A2;$F$1) in B2 and fill down.
Independent outputs are 0, 0, 1, 1 and 1. Their sum is 3, counting records at or above the chosen cutoff. The absolute reference keeps the threshold fixed as the input row changes.
Enter =A2-$F$1 in C2 and fill down. Differences are -2, -1, 0, 1 and 2. The row equal to ten has indicator one but difference zero, showing why these two columns answer different questions.
Example 2: make the zero default explicit
For -2, 0 and 3, the omitted-threshold formulas GESTEP(-2), GESTEP(0) and GESTEP(3) have independent targets 0, 1 and 1.
These match GESTEP with an explicit second argument zero. The result at zero is one, so this is not a strictly-positive test. Use an explicit Number>0 comparison if equality must be excluded.
The official example =GESTEP(5;1) targets one because five exceeds one. Add an equality control such as GESTEP(1;1) when validating the inclusive boundary; an above-threshold example alone cannot distinguish >= from >.
Advanced application: construct a half-open band
=GESTEP(A2;10)-GESTEP(A2;20) is an indicator for 10<=A2<20. For input values 9, 10, 15, 20 and 21, independent outputs are 0, 1, 1, 0 and 0.
The upper-bound step switches on at twenty and subtracts the lower-bound indicator there. That makes the upper endpoint exclusive without subtracting an arbitrary epsilon from it.
Keep the lower and upper bounds in labeled parameter cells when building a reusable worksheet. Reversing their order produces a different signed expression rather than the intended interval.
Advanced application: weight the passing rows
For the five-value dataset 8 through 12, put weights 2, 3, 4, 5 and 6 in D2:D6. Use =B2*D2 in E2 and fill down. Independent contributions are 0, 0, 4, 5 and 6, totaling 15.
This combines a binary condition with a separate quantity. The threshold should not be confused with the weight. Preserve the original measurement, indicator and weight so the total can be reconstructed row by row.
Errors and troubleshooting
A number slightly below Step still fails the direct comparison even if both values display as the same rounded decimal. If the intended rule compares rounded measurements, round to a defined unit before comparison and document that policy. GESTEP does not decide the acceptable tolerance.
The optional-argument default is not proof that every blank-looking text value is accepted as zero through every argument path. The first parameter and optional converter have distinct type handling. Native localized errors, text coercion and imported arrays were not tested.
A chosen threshold indicator does not establish the appropriateness of the cutoff or the validity of the data. Use it only for a rule whose inclusive endpoint and units have been explicitly defined.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help. This function’s cited help snapshot was retrieved on 2026-10-13 and hash-verified on October 15, 2026. Desktop documentation does not establish Online or mobile support. First introduction and last functioning release are unknown in this evidence.
No native Collabora Office execution occurred. Worked results are independent logical, calendar, structural or mathematical expectations. Formulas use English names and semicolon argument separators.
Implementation details are corroborated by Collabora current source, retrieved October 15, 2026. This moving-main snapshot is not a pinned 26.04 binary or an application test.