How to use GESTEP Function in Excel

GESTEP Function:

GESTEP(NUMBER, STEP) Function checks two parameters, NUMBER and STEP value (numeric) and returns

                             1) 1   (if NUMBER >= STEP)
                             2) 0   (if NUMBER < STEP)

STEP parameter is optional and If no value is supplied, then default value of 0 would be used for STEP. If non-numeric values are supplied for either NUMBER or STEP or Both, then GESTEP function returns #VALUE! error.

Consider marks scored by candidates in competitive exam. GESTEP can be used to determine whether a candidate has scored above average or below average as shown below.

    Similarly, GESTEP can be used in combination with IF function where, logical test of IF function evaluates to TRUE if GESTEP returns 1 and FALSE if GESTEP returns 0.