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)
|
|