Syntax
GESTEP(number, [step])
| Parameter | Description |
|---|---|
| number | Parameter of the GESTEP function. |
| [step] | (Optional.) Parameter of the GESTEP function. |
Examples
Test if value meets threshold
Formula
=GESTEP(5, 4)
1. 5 is greater than or equal to 4, so GESTEP returns 1.
Value below threshold
Formula
=GESTEP(3, 5)
0. 3 is less than 5, so GESTEP returns 0.
Count values meeting a minimum
Formula
=SUMPRODUCT(GESTEP(B1:B50, 75))
Counts how many values in B1:B50 are greater than or equal to 75. Each qualifying value contributes 1 to the sum.
Common Errors
#VALUE!
Either argument is non-numeric text.
Tips
Default step is zero
GESTEP(5) returns 1 because 5 >= 0. When step is omitted, it defaults to 0, so it tests whether the number is non-negative.
Use for pass/fail indicators
=GESTEP(score, 70) returns 1 for passing scores and 0 for failing, without needing an IF formula. Clean and concise.
Numeric output for calculations
Like DELTA, GESTEP returns 0 or 1 instead of TRUE/FALSE. This makes it directly usable in multiplication and SUMPRODUCT without conversion.
Try GESTEP in Viztab
Import your data and use GESTEP with 370+ other formulas. No signup required.
Open Viztab