SheetFX
≡
<< Go back to all functions

GESTEP

The GESTEP function in Google Sheets returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise. If no step value is provided, then the default value of 0 will be used. This function is useful for comparing values and determining if they meet a certain threshold.

Function Syntax and Parameters

Syntax: GESTEP(value, [step])

Parameters:

  • value: The value to compare against the step value.
  • step: [Optional] The step value to compare against. Default value is 0.

Step-by-Step Tutorial

  1. Using GESTEP with a value and step:

    • Example: =GESTEP(5, 3)
    • Result: 1

  2. Using GESTEP with a value only:

    • Example: =GESTEP(2)
    • Result: 0

Use Cases and Scenarios

  1. Rate Comparison: Determine if a rate is greater than or equal to a certain step value.
  2. Threshold Check: Check if a value meets a specific threshold requirement.

Related Functions

  • CEILING: Round a number up to a specified multiple.
  • FLOOR: Round a number down to a specified multiple.

Related Articles