GESTEP Function in Excel tests whether a supplied number is greater than or equal to the certain threshold. GESTEP Function returns 1, if supplied number is greater than or equal to threshold [step].GESTEP Function returns 0, if supplied number is less than threshold [step].
Syntax of GESTEP Function in Excel
GESTEP( number, [step] )
Where
number – The number to be tested.
[step] – An Optional argument that defines the step size i.e. threshold.
If [step] omitted, the default value 0 is used.
Example of GESTEP Function in Excel
Formula
- From Row number 2 to 5 GESTEP Function compares the value with specified threshold.
- In Row number 6 GESTEP Function compares -5 to 0(which is default threshold) and returns 0
- In Row number 7 GESTEP Function compares 5 to 0(which is default threshold) and returns 1
Result
NOTE: #VALUE! – Error occurs if
- The supplied arguments are non-numeric;