Spread WPF Documentation > Formula Reference > Formula Functions > GESTEP |
This function, greater than or equal to step, returns an indication of whether a number is equal to a threshold.
GESTEP(number,step)
This function has these arguments:
Argument | Description |
---|---|
number | Value to test against the step (which is either step or zero) |
step | [Optional] Value of the threshold against which to test; if omitted, uses zero |
If the number is greater than or equal to the step, this function returns one. Otherwise it returns zero.
Accepts numeric data for all arguments. Returns numeric (0 or 1) data.
GESTEP(B5,7)
GESTEP(43) gives the result 1