How to use GESTEP Function in Excel

The GESTEP function is used to compare if the given number is greater than or equal to the other number. The function returns 1 if it is greater than or equal to and returns 0 if it is not.

Syntax: GESTEP(number, [step])

The GESTEP function syntax has the following arguments:

  • Number    Required. The value to test against step.
  • Step    Optional. The threshold value. If you omit a value for step, GESTEP uses zero.

Example: Let’s look at some Excel GESTEP function examples and explore how to use the GESTEP function as a worksheet function in Microsoft Excel:

GESTEP Function - How to use GESTEP Function in Excel

Syntax:  =GESTEP(A2,B2)

Result:

GESTEP Function in Excel - How to use GESTEP Function in Excel

Based on the Excel spreadsheet above, the following GESTEP examples would return:

Syntax: =GESTEP(A3,B3)
Result: 1

Syntax: =GESTEP(A4,B4)
Result: 1

Syntax: =GESTEP(A5,B5)
Result: 0

Syntax: =GESTEP(A6,B6)
Result: 0

Syntax: =GESTEP(A7,B7)
Result: 1

Syntax: =GESTEP(A8,B8)
Result: 1

Syntax: =GESTEP(A9,B9)
Result: 1

Syntax: =GESTEP(A10,B10)
Result: 0

Syntax: =GESTEP(A11,B11)
Result: 1

Syntax: =GESTEP(A12,B12)
Result: 1

Syntax: =GESTEP(A13,B13)
Result: 1

Note:

  • If number is nonnumeric, GESTEP returns the #VALUE! error value.
  • If step is nonnumeric, GESTEP returns the #VALUE! error value.
READ:  How to use IMCOS Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *