GESTEP

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.
* 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!


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