GESTEP

Formulas / GESTEP
Filter values using GESTEP.
=GESTEP(number, [step])
  • number - required, the number to test
  • [step] - [OPTIONAL] integer, step argument

Examples

  • GESTEP(2,1)

    The GESTEP function returns a value of 1 if the number given is greater than or equal to the step value, and 0 if the number given is less than the step value. This example returns 1 since 2 is greater than or equal to 1.

  • GESTEP(A2,0)

    The GESTEP function can be used to determine whether a given value is greater than or equal to a certain number. For example, the formula above returns 1 if the value in cell A2 is greater than or equal to 0, and 0 if the value in cell A2 is less than 0.

  • IF(GESTEP(A2,0), "Positive","Negative")

    The GESTEP function can be used in an IF statement to check if a given number is greater than or equal to a certain value. For example, the formula above will return "Positive" if the value in cell A2 is greater than or equal to 0, and "Negative" if the value in cell A2 is less than 0.

  • COUNTIF(A2:A10,GESTEP(A2:A10,0))

    The GESTEP function can be used to count the number of values that are greater than or equal to a certain value. For example, the formula above will count the number of cells in the range A2:A10 that are greater than or equal to 0.


Summary

The GESTEP function is a tool used to calculate the number of values that meet a given criterion. It requires one argument and optionally takes a second argument as the threshold value.

  • The GESTEP function is used to filter a set of values by returning a number if the argument is greater than or equal to the step argument.

Frequently Asked Questions

What is the GESTEP function?
The GESTEP function is a function in Sourcetable that returns a truth value based on whether the argument is greater than or equal to the step argument.
What arguments does the GESTEP function take?
The GESTEP function takes two arguments - a number argument, which is required, and a step argument, which is optional.
What happens if any argument is nonnumeric?
If any argument is nonnumeric, GESTEP will return #VALUE!
How do I use the GESTEP function?
To use the GESTEP function, enter the function in a cell and provide the required arguments. The syntax is as follows:
  • GESTEP(number, [step])
The number argument is required, while the step argument is optional.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV