GESTEP Function

Returns 1 if a number is greater than or equal to a threshold, otherwise 0.

Category

Engineering

Available in

All versions, Microsoft 365

Returns

1 or 0

Want to practice GESTEP in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

GESTEP ("greater-or-equal step") returns 1 when a number reaches a threshold (the step) and 0 when it's below.

Add a column of GESTEP results to count how many values passed — for example, reps who hit target.

Syntax

=GESTEP(number, [step])

Arguments

ArgumentRequired?What it does
numberYesThe value to test.
stepNoThe threshold. Leave it out to use 0.

Examples

Example 1 — Who hit the $50,000 target?

1 means the rep reached the target (exactly 50,000 counts).

C2fx=GESTEP(B2,50000)
ABC
1RepSalesHit
2Ana620001
3Ben485000
4Cy500001
5Di712501
=GESTEP(B2,50000) Explain

=SUM(C2:C5) shows 3 reps hit target.

Example 2 — Positive or not

With no step, GESTEP checks for zero or more.

=GESTEP(-4,-5) Explain

Returns 1, because −4 is greater than −5.

Common mistakes

  • #VALUE! The number or step is text.

Notes

  • =--(B2>=50000) gives the same answer.
  • Related functions: DELTA, IF, COUNTIF.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.