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

	A	B	C	D
1	NUMBER	STEP	RESULT	FORMULA USED in C Column
2	5	1	1	=GESTEP(A2,B2)
3	-2	-3	1	=GESTEP(B2,A5)
4	3		1	=GESTEP(B3,A2)
5	-1		0	=GESTEP(B4)
6	One	Zero	#VALUE!	=GESTEP(A6,B6)

	E
1	DESCRIPTION
2	Checks if the value in A2 (5) is greater than the value in B2(1)
3	Checks if the value in A3 (-2) is greater than the value in B3(-3)
4	Checks if the value in A4 (3) is greater than 0.
5	Checks if the value in A5 is greater than 0.
6	Returns Error as the value in both A6 and B6 is non-numeric

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: