A to Z of Excel Functions: the GESTEP Function
24 February 2020
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the GEOSTEP function.
The GESTEP function
It may sound like some sort of military walk, but the GESTEP function was used to assist filtering out data. Imagine you wanted to identify data that exceeded or was equal to some hurdle (target value). If you are familiar with the IF function, you might create a calculation such as
=IF(value >= hurdle, 1, 0)
In this case, if the variable value is greater than or equal to the hurdle, then a value of one (1) is returned, else zero (0). Well, guess what? There is a seemingly pointless Excel function out there that already does this for you. As a model auditor for more than 30 years, I can honestly say I have never seen the following function used in practice!
However, for completeness, the Excel function GESTEP returns one (1) if a compared number is greater than or equal to a “step;” (the given hurdle), otherwise it returns zero (0). This function may be used to filter a set of values. For example, by summing several GESTEP functions you can calculate the count of values that exceed a threshold.
GESTEP has the following syntax:
The GESTEP function has the following arguments:
- number: this is required, and represents the value to test against the hurdle, step
- step: this argument is optional. This is the threshold value; if this value is omitted, it is assumed to be zero (0).
It should be further noted that:
- if any argument is nonnumeric, GESTEP returns the #VALUE! error value.
Please see my example below:
We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every business day.
A full page of the function articles can be found here.