GESTEP

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!