GESTEP


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

Syntax:

GESTEP(number, stepnumber)

returns 1 if number is greater than or equal to stepnumber (both being numbers). If stepnumber is omitted it is assumed to be 0.

Example:

GESTEP(4, 5)
returns 0.
GESTEP(4, A1)
where cell A1 contains 4, returns 1.
GESTEP(2)
returns 1, because 2 is greater than 0.
=A1>=5
in a cell, where cell A1 contains 4, shows FALSE, as 4 is not greater than or equal to 5. This approach is very similar to GESTEP but does not trap non-numeric arguments.






 
Created with Zapof