GESTEP
Description
Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values. For example, by summing several GESTEP functions you calculate the count of values that exceed a threshold.
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 the default value as zero.
Sample Usage
Remark
If any argument is nonnumeric, GESTEP returns the #VALUE! error value.
Sample Usage
In order to use the GESTEP formula, start with your edited Excellentable:
Then type in the GESTEP formula in the area you would like to display the outcome:
By adding the values you would like to calculate the DATE formula for, Excellentable will generate the outcome: