Use Of GESTEP
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)
| |||
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें