GESTEP Function in Google Sheets

Compare a value to a step value using the GESTEP function.

GESTEP Function

The GESTEP function in Google Sheets is used to compare a number to a step value. It returns 1 if the number is greater than or equal to the step, and 0 otherwise.

Syntax

GESTEP(value, [step])
  • value: The number to compare against the step value. This is a required parameter.
  • step: (Optional) The step value to compare to. If omitted, it defaults to 0.

Examples

  1. Compare to Default Step 0

Check if 5 is greater than or equal to 0:

=GESTEP(5)

This will output 1.

  1. Compare to Custom Step 3

Check if 2 is greater than or equal to 3:

=GESTEP(2, 3)

This will output 0.

  1. Compare Negative Values

Check if -2 is greater than or equal to -5:

=GESTEP(-2, -5)

This will output 1.

Notes

  • The GESTEP function is useful in scenarios where conditional checks against a threshold are required.
  • It supports both positive and negative values.
  • IF: Perform logical tests and return different values based on the test results.
  • LE: Check if one value is less than or equal to another.