GESTEP

GESTEP(number [,step])

Returns the value True or False depending if the number is greater than a threshold value.

number	The value to test against the step value.
step	(Optional) The threshold value.

REMARKS

* If "number" >= "step", then 1 is returned.
* If "number" < "step", then 0 is returned.
* If "step" is left blank, then 0 is used. See Example 7
* If any of the arguments are not numeric, then #VALUE! is returned.
* This function can be used to filter out values.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=GESTEP(3, 4) = 0
2	=GESTEP(5, 4) = $1.00
3	=GESTEP(5, 5) = $1.00
4	=GESTEP(-4, -5) = $1.00
5	=GESTEP(15, 14) = 1
6	=GESTEP(2.5, 4) = 0
7	=GESTEP(2.5, 0) = 1
8	=GESTEP(2.5) = 1
9	=GESTEP("some text") = #VALUE!