Excel functions / Math
GESTEP function
Tests whether a number reaches a threshold: 1 when it is greater than or equal to the step, 0 when it is not.
Syntax
=GESTEP(number, [step])
Arguments
number: The number to test.step(optional): The threshold. Left out, it is 0.
When to use it
GESTEP gives 1 when a number is at or above a threshold and 0 when it is below. Summed, it counts how many reached the mark.
Examples
How many reached 50
A B C 1 Score 2 72 2 3 48 4 90 In C2:
=GESTEP(A2, 50)+GESTEP(A3, 50)+GESTEP(A4, 50)→ 2
Common mistakes
- A range. GESTEP takes one number at a time. For a range, COUNTIF(A2:A4, ">=50") is simpler.
GESTEP in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: GESTEP
- Danish: GETRIN
- Dutch: GROTER.DAN
- Finnish: RAJA
- French: SUP.SEUIL
- German: GGANZZAHL
- Hungarian: KÜSZÖBNÉL.NAGYOBB
- Italian: SOGLIA
- Norwegian: GRENSEVERDI
- Polish: SPRAWDŹ.PRÓG
- Portuguese (Brazil): DEGRAU
- Portuguese (Portugal): DEGRAU
- Russian: ПОРОГ
- Spanish: MAYOR.O.IGUAL
- Swedish: SLSTEG
- Turkish: BESINIR