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

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

  1. How many reached 50

    ABC
    1Score
    2722
    348
    490

    In C2: =GESTEP(A2, 50)+GESTEP(A3, 50)+GESTEP(A4, 50) → 2

    Try this example

Common mistakes

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.

Translate a whole formula

Try GESTEP in the playground

Related functions