Returns 1 if a number is greater than or equal to a threshold, and 0 otherwise.
Syntax
GESTEP(number, [step])Argumente
numbererforderlich
The value to test against the step.
stepoptional
The threshold value. If omitted, 0 is assumed.
The GESTEP function is used to filter a set of values by returning 1 for values that meet or exceed a specified step. If the step argument is omitted, Excel defaults to zero. This function is particularly useful for creating binary indicators in data analysis.
=GESTEP(5, 4)→1Since 5 is greater than 4, the function returns 1.
=GESTEP(2, 5)→0Since 2 is less than 5, the function returns 0.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =GESTEP(number, step) and replace the arguments with your specific values or cell references.
If the step argument is omitted, Excel uses 0 as the default threshold.
No, GESTEP is designed to return only 1 or 0 based on the comparison result.