September 17, 2021

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 COMPLEX Function in Excel

Leave a Reply

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