Functions
GESTEP
Test whether a number is greater than or equal to a step value
Try it
When to use it
When should I use GESTEP?
Use GESTEP to test whether a number is greater than or equal to a threshold, returning 1 (true) or 0 (false) — useful for counting values that meet or exceed a step without an IF formula.
Used in
Syntax
GESTEP(number, [step])Examples
=GESTEP(5,2) // => 1
=GESTEP(2,2) // => 1
=GESTEP(-6,-1) // => 0