Navigation:  Formula Reference > Spreadsheet Formula Functions >

GESTEP

Previous pageReturn to chapter overviewNext page

 

This function, greater than or equal to step, returns an indication of whether a number is equal to a threshold.

Syntax

GESTEP(number,step)

Arguments

This function has these arguments:

Argument

Description

number

Value to test against the step (which is either step or zero)

step

[Optional] Value of the threshold against which to test; if omitted, uses zero

Remarks

If the number is greater than or equal to the step, this function returns one. Otherwise it returns zero.

Data Types

Accepts numeric data for all arguments. Returns numeric (0 or 1) data.

Examples

GESTEP(B5,7)

GESTEP(43) gives the result 1

 

See Also

DELTA