GESTEP function

GESTEP (Number, Step?) GESTEP (Number; Step?)

Number

Number Number

The number to test.

Number Number (optional)

The step number. If omitted, it is assumed to be 0.

Number Number

1 Or 0.

Returns 1 if a number is greater than or equal to a step number, or 0 otherwise.

GESTEP (4, 5)

GESTEP (4; 5)

Returns 0.

GESTEP (5, 5)

GESTEP (5; 5)

Returns 1.

GESTEP (6, 5)

GESTEP (6; 5)

Returns 1.

SUM ( GESTEP ({ 3, 5, 7 }, 5))

SUM ( GESTEP ({ 3; 5; 7 }; 5))

Returns 2, the number of array elements that are greater than or equal to 5.