SpreadJS Documentation
GESTEP
SpreadJS 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.

Syntax

GESTEP(number,step)

Arguments

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

Remarks

If the number is greater than or equal to the step, this function returns one. Otherwise it returns zero.

Data Types

Accepts numeric data for all arguments. Returns numeric (0 or 1) data.

Examples

GESTEP(B5,7)

GESTEP(43) gives the result 1

See Also