GESTEP(number [,step])

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

numberThe 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.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.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!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top