Returns 1 if a number is greater than or equal to a threshold, and 0 otherwise.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
GESTEP(number, [step])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)Risultato: 1
Since 5 is greater than 4, the function returns 1.
=GESTEP(2, 5)Risultato: 0
Since 2 is less than 5, the function returns 0.
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.