GESTEP
Returns 1 if a number is greater than or equal to a step number, or 0 otherwise.
Syntax:
GESTEP(number, stepnumber)
returns 1 if number is greater than or equal to stepnumber (both being numbers). If stepnumber is omitted it is assumed to be 0.
Example:
GESTEP(4, 5)
returns 0.
GESTEP(4, A1)
where cell A1 contains 4, returns 1.
GESTEP(2)
returns 1, because 2 is greater than 0.
=A1>=5
in a cell, where cell A1 contains 4, shows FALSE, as 4 is not greater than or equal to 5. This approach is very similar to GESTEP but does not trap non-numeric arguments.
Application:
Employee Performance Bonus
Imagine a company that awards a performance bonus to its sales team. The bonus is awarded only if a salesperson reaches a sales target of $50,000 or more in a given quarter. We can use the GESTEP function to quickly determine who qualifies for the bonus.
Table: Sales Performance Q3 2025
Salesperson | Quarterly Sales | Sales Target | Qualifies for Bonus? (Using GESTEP) | ||
|---|---|---|---|---|---|
A | B | C | D | ||
1 | John Smith | $65,000.00 | $50,000.00 | GESTEP(B1, C1) | |
2 | Jane Doe | $48,000.00 | $50,000.00 | GESTEP(B2, C2) | |
3 | Peter Jones | $55,000.00 | $50,000.00 | GESTEP(B3, C3) | |
4 | Emily White | $72,000.00 | $50,000.00 | GESTEP(B4, C4) | |
5 | David Lee | $49,500.00 | $50,000.00 | GESTEP(B5, C5) |
Explanation:
- B1:B5 contains the actual sales achieved by each salesperson.
- C1:C5 contains the sales target, which is $50,000.
- The formula in the "Qualifies for Bonus?" column uses GESTEP to compare the "Quarterly Sales" to the "Sales Target."
- GESTEP(B1, C1) checks if the value in B1 ($65,000) is greater than or equal to the value in C1 ($50,000). Since it is, the function returns 1.
- GESTEP(B2, C2) checks if the value in B2 ($48,000) is greater than or equal to the value in C2 ($50,000). Since it is not, the function returns 0.
Resulting Table:
Salesperson | Quarterly Sales | Sales Target | Qualifies for Bonus? (Using GESTEP) | ||
|---|---|---|---|---|---|
A | B | C | D | ||
1 | John Smith | $65,000.00 | $50,000.00 | 1 | |
2 | Jane Doe | $48,000.00 | $50,000.00 | 0 | |
3 | Peter Jones | $55,000.00 | $50,000.00 | 1 | |
4 | Emily White | $72,000.00 | $50,000.00 | 1 | |
5 | David Lee | $49,500.00 | $50,000.00 | 0 |
This simple use of GESTEP quickly gives a binary result (1 for yes, 0 for no) that makes it easy to perform further calculations. For instance, you could multiply the bonus amount by the GESTEP result to calculate the actual bonus payout for each person.
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof