The GESTEP function returns 1 if the rate is strictly greater than or equal to the provided step value, or 0 otherwise. If no step value is provided, then the default value of 0 is used.

Parts of a GESTEP function

GESTEP(value,[step])

PartDescriptionNotes
valueThe value to test against the step number.
stepThe value to be tested against. It’s 0 if the argument is left blank.[OPTIONAL]

Sample formulas

GESTEP(5, 2) GESTEP(2) GESTEP(-0.00001) GESTEP(-6, -1)

Notes

If either value or step is non-numeric, GESTEP returns #VALUE!

Examples

AB
1Formula
2GESTEP(5, 2)
3GESTEP(2)
4GESTEP(-0.00001)
5GESTEP(-6, -1)

DELTA: Compare two numeric values, returning 1 if they’re equal.