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
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to test. |
| step | No | The 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)
| A | B | C | |
|---|---|---|---|
| 1 | Rep | Sales | Hit |
| 2 | Ana | 62000 | 1 |
| 3 | Ben | 48500 | 0 |
| 4 | Cy | 50000 | 1 |
| 5 | Di | 71250 | 1 |
=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

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.