Excel Function : GESTEP
Category
Engineering
Description
Tests whether a number is greater than a threshold value
Microsoft Excel Reference Page
https://support.office.com/en-us/article/GESTEP-function-f37e7d2a-41da-4129-be95-640883fca9df
Syntax and Description of the GESTEP Excel Function
=GESTEP(number,step) The GESTEP function syntax has the following arguments: Number Required. The value to test. Step Required. The number that represents the interval between test values. Example Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data. =GESTEP(A1,10) Result Function syntax GESTEP(number,step) Arguments Name Required
About GESTEP Excel Function
The GESTEP function returns the number 1 if the first argument is greater than the step argument, and 0 otherwise. The step argument is optional and defaults to 1.
