Returns 1 if number ≥ step, 0 otherwise.
Sample Usage
GESTEP(5, 2)
GESTEP(C5)
Syntax
GESTEP(value, [step])
- value - The value to test against the step number.
- step - [OPTIONAL] The value to test against the step number.
Examples
GESTEP(5, 2) checks whether 5 is greater than or equal to the step value 2, and returns a result 1.
GESTEP(C5) checks whether the number contained in C5 is greater than the default step value, 0.
Notes
- If either value or step is non-numeric, GESTEP returns #VALUE!