GESTEP Function (Functions in Excel)
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) |
0 comments:
Post a Comment