GESTEP function
GESTEP returns 1 if a number is at least a threshold and 0 otherwise. Used with SUMPRODUCT, it can count how many values reach a limit.
Example
Read it as a sentence: check whether 5 is greater than or equal to the step value 4, which gives 1 for yes.
A
B
C
D
1
1
2
3
Syntax
GESTEP(number, [step])
Arguments in [square brackets] are optional.
-
number(required) - The value to test.
-
step(optional) - The threshold; default 0.
Returns: 1 if number is at least step, otherwise 0.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=GESTEP(5,4) | 1 | 5 >= 4 |
=GESTEP(5,5) | 1 | Equal |
=GESTEP(3,4) | 0 | Below |
=GESTEP(-1) | 0 | Step omitted |
=GESTEP(0) | 1 | Zero step omitted |
=GESTEP("5","4") | 1 | Text number |
=GESTEP("a") | #VALUE! | Text |
=GESTEP(TRUE,1) | #VALUE! | TRUE |
Watch out for
- Equal values return 1.
Where it works
- Excel
- GESTEP is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .