GESTEP in Excel: Inclusive Threshold Flags and Weighted Counts
Use Excel GESTEP for greater-than-or-equal threshold tests, preserve equality at the boundary and combine numeric indicators for bands and weighted totals.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: GESTEP(number,[step]) returns numeric 1 when number is greater than or equal to step, and 0 otherwise. The default threshold is zero. Equality belongs to the included side of the boundary.
Availability and version history
- Introduced: the first introduction version is not established by the reviewed official history.
- Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
- Checked: October 14, 2026; official GESTEP reference. Documentation and independent models; no native Excel execution or wider platform certification.
Syntax and boundary meaning
=GESTEP(number,[step])
Number is required; step is optional and defaults to zero. Microsoft documents #VALUE! for a nonnumeric argument.
The source’s informal description mentions values that exceed a threshold, but its explicit definition and equal-value example establish an inclusive greater-than-or-equal rule. Do not use GESTEP alone when the requirement is strictly greater than.
The output is a numeric indicator, not the amount above the threshold. A value far above the threshold and a value exactly at it both return 1. Blank coercion, imported text and all floating-point boundary behavior remain outside the native testing scope.
Example 1: count values meeting a threshold
Enter 48, 50, 51, 72 and 49 in A2:A6, and the threshold 50 in D1. In B2 enter and fill down:
=GESTEP(A2,$D$1)
Expected indicators are 0, 1, 1, 1 and 0. =SUM(B2:B6) gives 3, the number at or above 50. The value exactly equal to 50 is included.
For a strictly-greater count, the independent comparisons A2:A6>50 identify only 51 and 72, giving 2. The difference is the observation on the boundary.
Changing D1 to 51 makes the GESTEP indicators 0, 0, 1, 1 and 0, totaling 2. An anchored threshold cell makes this policy change explicit and keeps copied formulas consistent.
Example 2: distinguish the zero default from equality with zero
Enter −2, 0, 0.5 and 4 in F2:F5. Use =GESTEP(F2) in G2 and fill down. Expected results are 0, 1, 1 and 1.
The sum is 3, the number of nonnegative values. DELTA with its omitted second argument would instead flag only the exact zero, producing 0, 1, 0 and 0.
A negative threshold is also valid for numeric comparisons. With step −3, values −4, −3 and −2 give indicators 0, 1 and 1. The inclusive rule remains the same on either side of zero.
Advanced example: combine two steps into a half-open band
Suppose a report includes values at least 50 but below 70. Enter 49, 50, 60, 70 and 71 in I2:I6. In J2 use:
=GESTEP(I2,50)-GESTEP(I2,70)
Fill down. The lower-threshold flags are 0, 1, 1, 1 and 1. The upper-threshold flags are 0, 0, 0, 1 and 1. Their differences are 0, 1, 1, 0 and 0, selecting exactly 50 and 60.
The upper endpoint 70 is excluded because both indicators are 1 there. This constructs a half-open interval [50,70), not a closed interval including both endpoints.
Keep the thresholds in the intended order. Reversing them would create negative differences for some observations and would no longer be the desired 1/0 band indicator. That is a modeling error, not a special function behavior.
Advanced example: weight qualifying observations
Use the original scores 48, 50, 51, 72 and 49 in L2:L6, with weights 2, 3, 1, 4 and 5 in M2:M6. In N2 enter and fill down:
=GESTEP(L2,50)*M2
Expected weighted contributions are 0, 3, 1, 4 and 0, totaling 8. The unweighted qualifying count remains 3. A weighted total and a row count answer different questions even though they use the same threshold flags.
The weights total 15, so the fraction of total weight meeting the threshold is 8/15, approximately 53.3333333%. The fraction of rows meeting it is 3/5, or 60%. State which denominator the report uses.
Interpretation and practical checks
=GESTEP(50,50) returns 1 and =GESTEP(49,50) returns 0. The amount above threshold is instead =MAX(0,number-step) for a separately defined positive-excess model; it is not GESTEP’s output.
For ordinary conditional counting, COUNTIF can express a numeric >= criterion directly. SUMIF can aggregate qualifying values. The helper-indicator approach is useful when the individual inclusion decisions need to remain visible.
Do not replace a nonnumeric-input error with zero without marking the invalid record. Otherwise a failed comparison becomes indistinguishable from a valid below-threshold observation. Exact native coercion and floating-point edge cases remain untested.
References and verification
Expected outputs are independently calculated examples or documented rules, not captured native Excel results. Formulas use English function names and comma argument separators. Locale, rendering and boundary restrictions are stated where relevant.