GESTEP Formula in Excel

 

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 totaled.