GESTEP
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.
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)
=GESTEP(NumberToTest,NumberToTestAgainst)
Formatting
No special formatting is needed.
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.
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.
