Related Function:

The GESTEP function returns 1 if number ≥ step; returns 0 (zero) otherwise.

Syntax

=GESTEP(number,[step])

Arguments

Argument Description
number The value to test against step
[step] Optional. The threshold value

  If [step] is omitted, GESTEP uses the default value zero (0)

Examples

  A B C
1 Formula Result Notes
2 =GESTEP(5,4) 1 Checks whether 5 is greater than or equal to the [step] value 4
3 =GESTEP(4,4) 1 Checks whether 4 is greater than or equal to the [step] value 4
4 =GESTEP(-4,-5) 1 Checks whether -4 is greater than or equal to the [step] value -5
5 =GESTEP(-0.05) 0 Checks whether -0.05 is greater than or equal to the default [step] value 0

Usage note: Use this function to filter a set of values. For example, by summing several GESTEP functions you calculate the count of values that exceed a threshold.

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric
#NAME? Occurs when Analysis ToolPak add-in is not enabled