Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
GESTEP
Returns 1 if a number is greater than or equal to a threshold and 0 otherwise.
Rarely usedDifficulty 1250 · ProficientUsage rank #373 of 520
When to use it
Returns 1 when a number is at or above a threshold and 0 otherwise. A step function you can sum.
The shape of it
- Syntax
=GESTEP(number, [step])
Worked examples
Above
=GESTEP(5,4) → 1
5 is at least 4.
Equal
=GESTEP(5,5) → 1
Equal counts.
Default threshold
=GESTEP(-1) → 0
The step defaults to 0, and -1 is below it.
Worth knowing
- Count values at or above a threshold: SUMPRODUCT(GESTEP(range,threshold)).
- --(x>=step) is the general-purpose equivalent.
- Step defaults to 0.
Where it goes wrong
- #VALUE! for text.
- Only numbers; dates work because they are numbers.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.