Engineering - GESTEP Function

Description

The GESTEP function returns −

1 if number ≥ step
0 (zero) if number < step

You can 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])

Arguments

Argument	Description	Required/ Optional
number	The value to test against step.	Required
step	The threshold value. If you omit a value for step, GESTEP uses zero.	Optional

Argument

Description

Required/ Optional

number

The value to test against step.

Required

step

The threshold value.

If you omit a value for step, GESTEP uses zero.

Optional

Notes

If number is nonnumeric, GESTEP returns the #VALUE! error value.
If step is nonnumeric, GESTEP returns the #VALUE! error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_engineering_functions.htm