GEStep Formula

	Number1	Number2	GESTEP
	10	20	0	=GESTEP(C4,D4)
	50	20	1	=GESTEP(C5,D5)
	99	100	0	=GESTEP(C6,D6)
	100	100	1	=GESTEP(C7,D7)
	101	100	1	=GESTEP(C8,D8)
	2		1	=GESTEP(C9,D9)
		2	0	=GESTEP(C10,D10)
What Does It Do ?
This function test a number to see if it is greater than or equal to another number.
If the number is greater than or equal, the result of 1 will be shown, otherwise 0 is shown.
Syntax
=GESTEP(NumberToTest,NumberToTestAgainst)
Formatting
No special formatting is needed.
Example
The following table was used to calculate how many sales staff achieved their targets.
The =GESTEP() function compares the Sales with Target, and the results are totalled.
	Name	Sales	Target	GESTEP
	Alan	£3,000	£4,000	0	=GESTEP(D27,E27)
	Bob	£5,000	£4,000	1	=GESTEP(D28,E28)
	Carol	£1,000	£2,000	0	=GESTEP(D29,E29)
	David	£2,000	£2,000	1	=GESTEP(D30,E30)
	Eric	£8,000	£7,000	1	=GESTEP(D31,E31)
			Targets Achieved	3	=SUM(F27:F31)