GESTEP in Google Sheets: Count Inclusive Thresholds and Build Bands

• Introduced: first introduction date is not established by the reviewed official history; no desktop release number is inferred.
• Availability: documented in the rolling Google Sheets service; these examples use the web worksheet workflow.
• Checked: October 14, 2026; official GESTEP reference. Documentation and independent models, with no native Sheets execution or wider client certification.

=GESTEP(value,[step])

Value is the quantity being tested; step is the threshold. Google’s introductory wording includes both “strictly” and “greater than or equal,” but the actual stated relation includes equality. The controls below therefore distinguish an inclusive threshold from a strictly greater-than comparison.

The dedicated reference documents #VALUE! when either supplied argument is nonnumeric. It does not establish a complete blank, Boolean or numeric-text coercion matrix. Use actual numeric inputs when reproducing the examples.

GESTEP returns a numeric flag, not the original quantity or the amount by which it exceeds the threshold. Use a separate subtraction if that difference is the question you need to answer.

Enter the following scores in A2:A6 and put threshold 70 in D2. Enter =GESTEP(A2,$D$2) in B2 and fill through B6.

=SUM(B2:B6) returns three. The score exactly equal to 70 is included. A strict comparison =A2>$D$2, filled down and counted as TRUE values, would include only two records.

For an explicit boundary control, =GESTEP(70,70) returns 1 while =GESTEP(69,70) returns zero. Raising D2 to 75 changes the flags to 0,0,1,1,0 and the count to two.

This is useful for a report whose specification says “at least.” It is not a substitute for deciding whether the business rule actually includes the boundary.

Omission tests against zero, not against an assumed positive threshold. Equality at zero is included. An explicit negative threshold is also an ordinary numeric comparison; the signs alone do not determine the result.

DELTA addresses equality, whereas GESTEP addresses ordering. A value such as 0.25 passes the default GESTEP threshold without being equal to zero.

To identify values at least 70 but below 90, subtract the upper-threshold flag from the lower-threshold flag:

=GESTEP(F2,70)-GESTEP(F2,90)

For F2:F6 containing 68, 70, 75, 90 and 95, the lower flags are 0,1,1,1,1 and the upper flags are 0,0,0,1,1. The differences are 0,1,1,0,0.

The lower endpoint is included and the upper endpoint is excluded. Reversing the two thresholds can produce negative flags, so validate their order before calling the result a membership indicator.

For an inclusive upper endpoint, use an explicit comparison formula such as =IF(AND(F2>=70,F2<=90),1,0). Do not adjust the threshold by an arbitrary tiny amount to imitate inclusivity.

Return D2 to 70 in the first fixture. Enter weights 2, 3, 5, 7 and 11 in C2:C6. In E2 use =B2*C2 and fill down.

The contributions are 0,3,5,7,0. Their sum is 15, while all weights total 28. The selected-weight fraction is 15/28, approximately 53.571429%, different from the selected-row fraction 3/5=60%.

Use =SUM(E2:E6)/SUM(C2:C6) for the weighted fraction. State what the weights measure; this formula is a transparent arithmetic example, not evidence that every weighting scheme is meaningful.

For numeric input in H2, use:

=10*GESTEP(H2,70)+20*GESTEP(H2,80)+30*GESTEP(H2,90)

Inputs 65, 70, 85 and 95 give 0, 10, 30 and 60. These are cumulative increments: reaching the highest threshold earns all three amounts. They are not mutually exclusive category payouts.

If the report instead requires exactly one category amount, an IF or lookup workflow should state that different policy explicitly.

=GESTEP("pending",70) and =GESTEP(70,"pending") follow the documented nonnumeric #VALUE! rule. The guide does not infer whether numeric-looking text or blank cells are coerced in every context.

The worked thresholds use small exactly specified integers or the exact fraction one quarter. Comparisons involving calculated decimal quantities close to a threshold require their own precision checks; changing a display format does not change the underlying comparison rule. No native Sheets execution was performed.

• Google GESTEP reference.
• Editorial testing standards.

Examples use fictional data, English function names and comma separators. Expected outputs are independent mathematical calculations or explicitly documented rules, not native Sheets captures. Check the spreadsheet locale when reproducing punctuation-sensitive formulas.