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 

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

GESTEP Function in Excel 1

  • 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

GESTEP Function in Excel 2

NOTE: #VALUE! – Error occurs if

  • The supplied arguments are non-numeric;

previous-small GESTEP Function in Excel                                                                                                                next_small GESTEP Function in Excel