GESTEP Function in Excel – Test whether the number is greater than threshold

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 

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;