Practice free

GESTEP function

GESTEP returns 1 if a number is at least a threshold and 0 otherwise. Used with SUMPRODUCT, it can count how many values reach a limit.

Example

Read it as a sentence: check whether 5 is greater than or equal to the step value 4, which gives 1 for yes.

Practice this in the app

Syntax

GESTEP(number, [step])

Arguments in [square brackets] are optional.

number (required)
The value to test.
step (optional)
The threshold; default 0.

Returns: 1 if number is at least step, otherwise 0.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=GESTEP(5,4) 1 5 >= 4
=GESTEP(5,5) 1 Equal
=GESTEP(3,4) 0 Below
=GESTEP(-1) 0 Step omitted
=GESTEP(0) 1 Zero step omitted
=GESTEP("5","4") 1 Text number
=GESTEP("a") #VALUE! Text
=GESTEP(TRUE,1) #VALUE! TRUE

Watch out for

  • Equal values return 1.

Where it works

Excel
GESTEP is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .