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